Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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/
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/
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |