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'm getting an error of dependence on the icrc in two separate "lookupvalue" columns. Does anyone know why this is a problem?
Allows a thin column. But it causes the error in a second column. Thank you!
Solved! Go to Solution.
Hi @DavidWaters100 ,
There is a good description for circular dependencies: https://www.sqlbi.com/articles/understanding-circular-dependencies/.
It does not allow to have two calculated columns that contain measures that are also based on that table. As a workaround, you may try to convert these into measures instead of column.
You can refer to the similar case: "A circular Dependency was detected" error while creating a calculated column.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DavidWaters100 ,
There is a good description for circular dependencies: https://www.sqlbi.com/articles/understanding-circular-dependencies/.
It does not allow to have two calculated columns that contain measures that are also based on that table. As a workaround, you may try to convert these into measures instead of column.
You can refer to the similar case: "A circular Dependency was detected" error while creating a calculated column.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Very difficult to troubleshoot circular dependencies. What does the text of the circular dependency say? It should call out the offending columns/measures involved. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
@DavidWaters100 , refer, if these two can help you to find
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
https://www.youtube.com/watch?v=s1S6gLhg26w
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |