Forum Discussion
Relation Between Queries
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 !
- Anonymous7 years ago
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
1 Reply
- AnonymousNot applicable
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