DAX measure column filter

Hi Jens,

Thank you for your quick response.

I'm still having an issue. I think the problem is the measure isn't changing based on how the table it's related to is filtered.

What I want to do in a way, is filter a table (table 1 below), so it would change from having a "many to many relationship" to a "one-to-many" relationship with another table.

Filter options (this represents different scenarios):
x,
y

Table 1:

Entity, Variable Option, Cat, Value
EUI, x, a, 10
EUI, x, b, 20
EUI, y, a, 5
EUI, y, b, 15

Table 2:

Ref, Cat, Measure column (result based on filter)
Unique_info_1, a,
Unique_info_2, b,
Unique_info_3, a,
Unique_info_4, b,

I want it so:

e.g.
If the filter chosen is x, table 3 looks like:

Ref, Cat, Measure column
Unique_info_1, a, 10
Unique_info_2, b, 20
Unique_info_3, a, 10
Unique_info_4, b, 20

If the filter chosen is y, table 3 looks like:

Ref, Cat, Measure column
Unique_info_1, a, 5
Unique_info_2, b, 15
Unique_info_3, a, 5
Unique_info_4, b, 15


Is there a simple way to do this using DAX with the format tables 1 & 2 are in?

Thanks for your help.

Ben