How to resolve/root cause an ambiguity error in relationships

[Syndicate_Admin]

So, I seem to understand this all the time. I try to make an active relationship and receive an error that says, in part:

"A direct active relationship between [Table 1] and [Table 2] cannot be entrusted because that would introduce ambiguity between [Table 3] and [Table 1]"

For example.

So, is there an approach to root causing this and getting to the exact problem to address/fix?

Thank you

jrp

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Based on your description, the issue you may have faced is getting error on creating relationship between 2 tables and when this new relationship makes a circular path in the model. It will realise an ambiguity in reaching to the third table because there are 2 paths, one directly and another via an intermediate table.

So I suggest that you may need to re-adjust the relationship between the three tables or create a new table as a bridge to connect these tables. It depends on how your model was created. Please refer to the link below, I think it is very clear.

1. How to manage ambiguous relationship in Power BI

2. Bidirectional relationships and ambiguity in DAX 

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.