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 ()
        )
DanErickson's avatar
DanErickson
Frequent Visitor
2 years ago

I appreciate you sticking with me on this.  I have a screenshot below.  I have copied and pasted the DAX I used for the first calculated column, but updated the references to refer to a different column from the table and a different measure.  So it shouldn't be dependant at all on the first calculated column, but I still get the error.  I would like to have 4 calculated columns that correspond to the 4 regular columns from the table.  I should also mention that the measure that is pulled in here (CC Aud Cap or EP Aud Cap) is pulled from a different dataset entirely and in in no way dependent on any of the data in this table.

Thank you!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DanErickson ,

 

Based on the error message, it seems to be related to the [CC Aud 1000 Categories] in your table as well. Please provide sample data if you can.

 

Best regards,
Community Support Team_ Scott Chang