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

  • DanErickson's avatar
    DanErickson
    Frequent Visitor
    2 years ago

    The [CC Aud 1100 Categories] is the first calculated column.  I agree that the error is saying it is dependent on that column, but they don't reference each other at all.  They both use the same DAX, just pointed to different references.  My understanding is that once you have one calculated column, it changes the filter context, so other calculated columns become dependent, even if there is no actual circular reference.  This is what I am trying to fix.

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