bidirectional relationships

[powerbiexpert22]

what are the different ways to handle bidirectional relationships in power bi ? 

[Greg_Deckler · Accepted solution]

@powerbiexpert22 Please elaborate. You can have bidirectional relationships in Power BI or you can create a relationship single direction relationship and activate it bidirectionally only for the duration of a DAX query using the CROSSFILTER function.

[djurecic · Accepted solution]

https://learn.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering

https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/

https://www.youtube.com/watch?v=90tSVAls8t0

[Uzi2019 · Accepted solution]

Hi @powerbiexpert22 

Check this video you Bidirectional relationship doubts will be cleared.

https://www.youtube.com/watch?v=30OrlrKbXsw

https://www.youtube.com/watch?v=x3m7qzsVJqQ&t=170s

https://www.youtube.com/watch?v=c_kUNlmrqi8

https://www.youtube.com/watch?v=OOs-VWf20E8

I hope above videos would clear your doubts!

[djurecic · Accepted solution]

https://learn.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering

https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/

https://www.youtube.com/watch?v=90tSVAls8t0

[Greg_Deckler · Accepted solution]

@powerbiexpert22 Please elaborate. You can have bidirectional relationships in Power BI or you can create a relationship single direction relationship and activate it bidirectionally only for the duration of a DAX query using the CROSSFILTER function.