optimize solution for creating Relation

[dombarg]

hello.

which one is optimze from performance point of view:

create a Bridge table  => then make physical relationship between two table and => write a simple dax,

OR

create a virtual relation with Variables in Dax without creating bridge table and physical relation?

thanks

[v-chuncz-msft · Accepted solution]

@dombarg,

You may take a look at the links below.

• https://www.sqlbi.com/articles/costs-of-relationships-in-dax/
• https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/