Circular Dependency

[LucasFioriniBra]

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!

[mahoneypat · Accepted solution]

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