Forum Discussion
Help, ambiguity and crossfilter isssues
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.
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.
1 Reply
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.