Forum Discussion

JVP's avatar
JVP
Helper II
4 years ago
Solved

Circular dependency error for calculated column

Hi everyone, I would be grateful if you could help me understand what is causing this error:

 

<pi>A Circular dependency was detected: MyTable[Overdue Review], Risk Register[Overdue Actions], Risk Register[Overdue Review],</pi> 

 

I am trying to create 2 calculated columns to use for slicers but the second one won't play ball:

I am trying to use measures to create the calculated columns:

 

Measure 1:  Expired Action = IF(MAX('MyTable'[Target Date])>TODAY(),1,0)

Calculated Table : Overdue Actions = IF('MyTable'[Expired Action]=1,"In Date","Overdue")


Measure 2: Expired Reviews = IF(MAX('MyTable'[Review Date])>TODAY(),1,0)

Calculated Table : Overdue Review = IF('MyTable'[Expired Reviews]=1,"In Date","Overdue")

 

I don't think any of the Columns depend on the each other? Please could you advise what might be the problem?

 

Need Help
  • JVP's avatar
    JVP
    4 years ago

    For some reason it seemed to do the job when I used a different DAX and not reference the measure in Column 2:

     

    IF(DATEVALUE('MyTable'[Review Date])>TODAY(),"In Date", "Overdue")

1 Reply

  • JVP's avatar
    JVP
    Helper II
    4 years ago

    For some reason it seemed to do the job when I used a different DAX and not reference the measure in Column 2:

     

    IF(DATEVALUE('MyTable'[Review Date])>TODAY(),"In Date", "Overdue")