Inactive relationship

[ilanas]

 

Hello,

I have a problem in the development of the data model and I don't know why. I have created a calendar table in the model. I relate this table to several tables, and this several tables are related with single table. It makes the relationship inactive. The relationships are not bidirectional so I don't know why it identifies as circular.
Thank you

[AlexisOlson · Accepted solution]

It looks like the relationships are not circular but they do create ambiguity if they are all active since the calendar table would have multiple paths that filter the final table.

Further reading:
https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/

[Anonymous]

What you are trying to do is not allowed. Your calendar table can only have 1 active relationship to the final table.
Consider union on table 1,2,3,4. Consider if your Final Table should be made with measures, not as a table.