Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Why I can't use many to many relationship more than once between two fact tables?
Solved! Go to Solution.
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.
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.