Relation Between Queries

[Ramyzo]

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 · Accepted solution]

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