There are ambiguous paths between tables connections

[pr92]

Hello, I have the following model in Power BI : 

Dimension tables : 

• D_Date with Year, Month and Day
• D_Products with Category, Subcategory and product 

Fact tables : 

• KPIs calculated based on Product Category and Month
• KPIs calculated based on Product Category and Year

In my report I have segments for Product Category and depending on the page, I will have 1 filter for Year or 1 filter for Month.

When creating the relationship between my D_Date and F_KPI_Yearly on column "Year" (Many to Many), I have the following error: 

Upon trying again I had this error in a prompt : 

There are ambiguous paths between 'F_KPI_Yearly' and 'D_Date' : 

'F_KPI_Yearly' -> 'D_Date' and  'F_KPI_Yearly' and 'D_Products' -> 'F_KPI_Yearly' -> 'D_Date'

What is the reason behind this error? How can I fix it?

Thank you in advances

[danextian · Accepted solution]

Hi @pr92 

By the looks of it, you are using relationships that travel in both directions. Change the direction of your relationships to single from Dimension to Fact tables.