Forum Discussion

sabd80's avatar
sabd80
Helper IV
1 year ago
Solved

Calculated Column error Circular dependency

Hi,

I am trying to create a few calculated columns from one table.

 

I had no issue creating the first one, Actual:

Actual = CALCULATE(sum('Consolidated Sales'[GrossSalesValue]),'Consolidated Sales'[Source]="Actual")
 
But for the second one, Budget, I get this error:

A circular dependency was detected: Consolidated Sales[Column], Consolidated Sales[Actual], Consolidated Sales[Column].

Budget = CALCULATE(sum('Consolidated Sales'[GrossSalesValue]),'Consolidated Sales'[Source]="Budget")
 
 
How can I fix this?
Need Help
  • sabd80's avatar
    sabd80
    1 year ago

    I solve it.

     

    Budget=
     IF('Consolidated Sales'[Source]="Budget", 'Consolidated Sales'[GrossSalesValue])

6 Replies

  • sabd80's avatar
    sabd80
    Helper IV
    1 year ago

    I solve it.

     

    Budget=
     IF('Consolidated Sales'[Source]="Budget", 'Consolidated Sales'[GrossSalesValue])
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, sabd80 

    Thanks for lbendlin's reply. You can provide a pbix file without sensitive data for testing. It might solve the problem faster.

    Best Regards,
    Yang
    Community Support Team