Cant create active relationship between tables cause that would introduce ambiguity btwn same tables

[pr92]

I have a model on Power BI with 4 dimension tables : 

• Date Table
• Product Table
• Country Table
• Channel Table

And 8 fact tables that contain various calculations.

All of the 8 fact tables have these relationships : 

• Fact_Table[Year] <> D_Date[Year] OR  Fact_Table[Month] <> D_Date[Month]
• Fact_Table[Country] <> D_Country[Country]
• Fact_Table[Channel] <> D_Channel[Channel]
• Fact_Table[Categ_Id] <> D_Products[Categ_Id] OR Fact_Table[Product_Id] <> D_Products[Product_Id]

I have just added a 9th fact table and created the following relationships : 

• Fact_Table9[Year] <> D_Date[Year] Many to Many OK 
• Fact_Table9[Country] <> D_Country[Country] Many to One OK
• Fact_Table9[Channel] <> D_Channel[Channel] Many to One OK
• Fact_Table9[Categ_Id] <> D_Products[Categ_Id] Many to Many ERROR on making the relationship active

I don't understand why the last relationship failed to become active, here is the exact error message : 

"You can't create a direct active relationship between Fact_Table9 and D_Products because that would introduce ambiguity between tables Fact_Table9 and D_Products. To make this relationship active, desactivate or delete one of the relationships between Fact_Table9 and D_Products first."

I tried to create another project on the side and take only Fact_Table8 and Fact_Table9 and then create the relationships with the 4 dimension tables, I had this error : 

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

'Fact_Table9' -> 'D_Date' and  'Fact_Table9' and 'D_Products' -> 'Fact_Table8' -> 'D_Date'

Did any of you get this error before ? 

Any help would be appreciated.

Thank you

[pr92]

What solved my problem was to change all the relationships in my model to have cross filter direction : Single

[Anonymous]

@pr92 

Thanks for NaveenGandhi help. After testing it doesn't seem to be simulating your problem as you suspected. If you don't currently have a problem, could you share a pbix file without sensitive data to test.

Best Regards,
Yang
Community Support Team

[NaveenGandhi]

HI @pr92 

Can you confirm if you have any relationship between the 9th fact table and other fact tables?

Regards,
NG

[pr92]

I think the problem comes from the fact that I can't have 2 many-to-many relationships on the same fact table. Did you ever have this problem?

[pr92]

Hello, I confirm that I don't have relationships between 9th fact table and other fact tables.