tabular model many to many relationship creaion

[prashant_ora]

Is there any way to create many to many relationship between tables without using bridge table.

[v-huizhn-msft]

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

[AlbertoFerrari]

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