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.
I have 2 calculated columns in a table that use an inactive relationship to a date dimension table. The first column works fine and the second column gives a circular reference error.
First Column
Thanks in advance
Hi @sjpaq,
Perhaps you can try to directly extract the current table value as conditional to filter and get the correspond table records to stored into the variable.
Then you can and manually use this in the formulas without USERELATIONSHIP function. (I think the issue should related to USERELATIONSHIP function and it may generate the temp relationship mappings for the calculations)
Understanding circular dependencies in DAX - SQLBI
Regards,
Xiaoxin Sheng
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 |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
2 | |
2 | |
2 |