Circular dependency detected - Calculated Columns

[Anonymous]

Hello Guys, I have created two Measures as below and it works.., Since it was a Measure i am unable to use the measure in Page Filter.

Is there any way to bring both columns as a Calculated Columns? Please help..,

Column 1 = CALCULATE(SUM('Dship'[Month 1]), 'Dship'[KEYFIG] IN { "GEO Forecast" })

Column 2 = CALCULATE(SUM('Dship'[Month 1]), 'Dship'[KEYFIG] IN { "Total Month Demand" })

With Regards,

Aswinraj A

[Greg_Deckler]

I'm not sure why that would cause a circular dependency from the information provided. Sample data and all that would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[amitchandak · Accepted solution]

You can do like this. But filter will be at like level

Column 1 = if ('Dship'[KEYFIG] IN { "GEO Forecast" } ,('Dship'[Month 1]),blank() )
Column 2 = if('Dship'[KEYFIG] IN { "Total Month Demand" },('Dship'[Month 1]),blank() )

[Anonymous]

@AM thank you soo Much.., it works 🙂

[Anonymous]

---

@amitchandak Can you please explain why that blank was added? So that i can learn something today newly.

---

---