Relationships Issues

[tarmilto1389]

I am trying to create a relationship between a market filter and a paid search spread sheet, but i keep getting a kick back that i need to delete one of date relationships in order to make the market relationship. I need the date relationship between all that are in the screenshot, and i am confused on what relationship between date label and market filter i need to remove - i need all of them! Any help?

[v-lili6-msft]

hi  @tarmilto1389 

This error is because introducing this join would create a loop kind of this in your datamodel there by resulting in ambiguity of the tables usage.

There have been a relationship between a market filter and a paid search spread sheet,

 for this relationship is not created directly on these two tables, there are other tables between these two tables like bridges in their relationship.

see more details, you refer to these:

https://stackoverflow.com/questions/65110059/you-cant-create-a-direct-active-relationship-between-a-...

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

http://cloudbi.com.au/how-to-manage-ambiguous-relationship-in-power-bi/

Regards,

Lin