Help, ambiguity and crossfilter isssues

[Anonymous]

I am creating a close loop relationships with three tables but when I try to get the three tables to relate with each other I get a crossfilter error or an ambiguity error. So when using the chiclet visualization it will only relate one table at a time to the other two tables but I need it to filter two tables into one showing all options from both tables. Help. Thanks.

[Anonymous · Accepted solution]

Hi @Anonymous ，

You cannot create a close loop relationships, which is not allowed in Power BI. Because multiple active relationships create conflicts, multiple relationships can lead to unclear dependencies between tables!
Relationships in Analysis Services tabular models | Microsoft Learn

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