Forum Discussion

Ramyzo's avatar
Ramyzo
Helper II
7 years ago
Solved

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 !

1 Reply

  • Anonymous's avatar
    Anonymous
    Not 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