Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there any way to create many to many relationship between tables without using bridge table.
Hi @prashant_ora,
There is no way to create many to many relatiomship between two tables without a brige table There are many-one or one-one relationship between tables, at least one column in one of the tables must contain unique values if you want to create relationship. More details, please review this article.
Best Regards,
Angelia
You could move a filter between any two tables by using rather complex sets of CALCULATE and TREATAS but performance would be horrible and the code would be very hard to manage.
So, the quick answer is "yes", the full one is: "yes, but why making your life so much harder? The golden rule says that m2m need a bridge, why do you want to avoid it"?
Have fun with DAX!
Alberto Ferrari
http://www.sqlbi.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |