Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Relationship Problem and filter direction

Hi, we have the attributes as Employee,Sales,Product,Country and the relationship between them as follows. we are facting filter problems in the following relationsip .The problem is we were un able...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    It's impossible to create relationship as below:

    Because if you do this, there are two relationship lines between the Sales table and the Country table. This is not allowed, and only one relationship can exist between the two tables.

    In fact, how you establish relationships between tables depends on how you want to create the visualization.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

You can duplicate your Country table or invoke the inactive relationship using USERELATIONSHIP function.

https://dax.guide/userelationship/

 

You probably want to swap you bidirectional relationship as well to one direction.

https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn