Forum Discussion
Solved
Creating a filter table to avoid having two onscreen filters - Ambiguous relationship
Hi there, In my current report I'm looking to filter 2 tables using one onscreen filter by introducing a helper table (user account details, and required training) by the same column type (team)....
Hi ZakJaconelli ,
You can refer the following links to try to resolve the ambiguous relationship problem.
Resolve relationship path ambiguity
Bi-directional relationships can introduce multiple, and therefore ambiguous, filter propagation paths between model tables. When evaluating ambiguity, Power BI chooses the filter propagation path according to its priority and weight.
Solved: Table relationship ambiguity - Microsoft Fabric Community
Understanding Ambiguity in Power Data Model - Microsoft Fabric Community
How to manage ambiguous relationship in Power BI – Cloud BI
Best Regards
Thank you, this is really helpful to understand how relationships interfact 🙂