Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Circular dependency detected - Calculated Columns

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
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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() )

4 Replies