Set direction for single relationship

apohl1 — Wed, 22 Dec 2021 10:13:52 GMT

Hi all,

Does anyone know why I'm not able to set the direction of the relationship between "Customer aggregation" table and "Raw data: sales" table in the 1st printscreen below (direction should be "Customer aggregation" filters "Raw data: sale" table)?

"Customer aggregation" table has only unique values and "Raw data: sales" table has many values. The reason why I want the direction this way is beucase I want "Customer aggregation" to be filtered based on same criterias as the "Raw data: sales" table.

Please see 2nd printscreen for the relationship I would like to se t up. When applying it the direction of the relationship always change to "Raw data: sales" table filters "Customer aggregation" and I don't understand why.

Thank you in advance!

Re: Set direction for single relationship

ValtteriN — Wed, 22 Dec 2021 10:27:21 GMT

Hi,

I am pretty sure you cant do what you are describing in a 1:* relationship. As a workaround you could change the relation to *:* and use single direction filtering. E.g. :

topic Re: Set direction for single relationship in DAX Commands and Tips

Set direction for single relationship

Re: Set direction for single relationship