Solved: Relation Between Queries

Ramyzo · ‎06-12-2019

Greeting ,

is it possible to have more than 1 active relation between my Queries ? i have created 3 table (Imported from my cube used MDX ) and now im trying to set relationship between them so i can use Filter on report level !

here is my exemple , thanks in advance !

Anonymous · ‎06-12-2019

Only 1 active relationship allowed. Though you can create multiple relationships. The active one will be a solid line while the inactive will be a dotted line. You can "turn on" the inactive relationship for the duration of a measure using USERELATIONSHIP

https://docs.microsoft.com/en-us/dax/userelationship-function-dax

View solution in original post

Anonymous · ‎06-12-2019

Only 1 active relationship allowed. Though you can create multiple relationships. The active one will be a solid line while the inactive will be a dotted line. You can "turn on" the inactive relationship for the duration of a measure using USERELATIONSHIP

https://docs.microsoft.com/en-us/dax/userelationship-function-dax