Calculated Column error Circular dependency

[sabd80]

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?

[sabd80 · Accepted solution]

I solve it.

Budget=

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

[DivkLearner]

Hello @sabd80, 

I tried the same sample and found the solution is to use "Measure" instead of "Calculated Column".

Let me know if you are looking for something specific and I can help you with it. 

Regards, 

DivKlearner, A bit forward daily. 

Link to my channel on Power BI.

https://www.youtube.com/watch?v=aADx2sPA2D0&list=PLDUIC70xSiVQQpfqGhOjBVDF8IBP2k6ob

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Anonymous]

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

[lbendlin]

is GrossSalesValue a calculated column?

[sabd80]

no