Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Many to many relationship

Why I can't use many to many relationship more than once between two fact tables?
Need Help
  • community_pinki's avatar
    community_pinki
    5 years ago

    Hey Anonymous ,

     

    We can create a multiple relationship between two tables but only one relationship will be active and remaining will be inactive shown in (dashed line).
    To activate the inactive relationship we can have a option , use USERELATIONSHIP() function in power bi DAX.

     



community_pinki's avatar
community_pinki
Icon for Helper II rankHelper II
5 years ago

Hey Anonymous ,

 

We can create a multiple relationship between two tables but only one relationship will be active and remaining will be inactive shown in (dashed line).
To activate the inactive relationship we can have a option , use USERELATIONSHIP() function in power bi DAX.