Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I need to create a fact table in my model based on 2 dimension tables. I used CROSSJOIN function and create table as below.
The problem is I cannot link it to the source dimension tables now, because it creates circular dependency error. Is there any solution for this?
Thanks, Kamil
Solved! Go to Solution.
Try using DISTINCT instead of VALUES. Also, make sure dDate is marked as a date table.
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Proud to be a Super User!
Hi @KamilSzpyrka ,
Has your problem been solved by @DataInsights's solution?
If so, Would you mind accept his reply as solution? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team _ kalyj
Thank you for the reminder. Mentioned solution works indeed. Topic can be closed.
Try creating the cross join in Power Query:
https://docs.microsoft.com/en-us/power-query/cross-join
Proud to be a Super User!
I can't do this, since one of the tables is calculated table created in DAX.
Try using DISTINCT instead of VALUES. Also, make sure dDate is marked as a date table.
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Proud to be a Super User!
It works indeed, thank you for your help.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |