Ambiguous relationships

• Power BI data models will reject ambiguous relationships, in which there are multiple possible cross filtering paths
• For example, a bridge table cannot have two many-to-one bidirectional relationships to tables (A and B), both of which have one-to-many, single-direction cross filtering relationships to table C
  • The model would not know (or try to guess) whether table A or B should be filtered prior to filtering table C
• Inactive relationships, cross filter direction, and the CROSSFILTER() function provide additional modeling flexibility