Forum Discussion

DanErickson's avatar
DanErickson
Frequent Visitor
2 years ago
Solved

Circular Dependency Issue

I am creating multiple Calculated Columns in a table, so I am running into circular dependancy issues.  I have ready everything that I can on how to fix this (understanding that creating more that on...
Need Help
  • DanErickson's avatar
    DanErickson
    2 years ago

    ChatGPT just provided me with a working solution.  My final DAX looks like:

    EP Aud 1100 Categories =
    VAR __VALEP = [East Paris]
    VAR __EP_Aud_Cap = CALCULATE([EP Aud Cap], REMOVEFILTERS(Aud1100))
    RETURN
        SWITCH (
            TRUE (),
            __VALEP <= (.4*__EP_Aud_Cap), "Low",
            __VALEP <= (.6*__EP_Aud_Cap), "Moderate",
            __VALEP <= (.8*__EP_Aud_Cap), "Ideal",
            __VALEP <= __EP_Aud_Cap, "High",
            __VALEP >= __EP_Aud_Cap, "Over Capacity",
            BLANK ()
        )
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DanErickson ,

 

Based on the DAX expression you provided, please make sure that [CC Aud Cap] does not participate in any calculations in [Cascade] seems to solve the problem. If you still have problems, please provide more information.

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.