Help With Relationships

Thanks for the reply from amitchandak , please allow me to provide another insight: 
Hi  jamiers ,

Based on the error message display, you can check the following:

The wrong active relationship is set. Generally, there can be only one active relationship between two tables. If there is more than one relationship, you need to set it as inactive.

Use the Manage relationships dialog box to set a relationship as active or inactive, or set the active relationship in the Edit relationship dialog box.

Specific screening instructions may also lead to errors. Therefore, you can refer to the specific official documentation below for information about the relationship modeling and activity relationships between constructed dimension tables and fact tables.

 specific screening directions may also cause errors.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Do the relationships in the table form a closed loop of Table A -> Table B - > Table C -> Table A. You can create a bridged table to act as an intermediate table, and the rest of the tables are connected to the bridged table.

Many-to-many relationship guidance - Power BI | Microsoft Learn

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

This is the related document, you can view this content:

Solved: Ambiguous paths between copies of the same table u... - Microsoft Fabric Community

Bidirectional relationships and ambiguity in DAX - SQLBI

Understanding Ambiguity in Power Data Model - Microsoft Fabric Community

Best Regards,

Liu Yang

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