Forum Discussion
LucasFioriniBra
3 years agoFrequent Visitor
Circular Dependency
Good evening people!
I'm trying to calculate a new column using a measure and another calculated column, but I get a circular dependency error:
HT Mix =
VAR UF = [Measeure]
return
(UF/100) * (24-table1[HM Mix])
The error message:
<ccon>A circular dependency was detected: table1[HT Mix], table1[HM Mix], table1[HT Mix].</ccon>
How can I solve that type of problem?
Thanks!
Please see this article. Basically, you need to use ALLEXCEPT in your expression to exclude the other calculated column.
Understanding circular dependencies in DAX - SQLBI
Pat
1 Reply
- mahoneypatMicrosoft Employee
Please see this article. Basically, you need to use ALLEXCEPT in your expression to exclude the other calculated column.
Understanding circular dependencies in DAX - SQLBI
Pat