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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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() )

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    AM thank you soo Much.., it works 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      amitchandak Can you please explain why that blank was added? So that i can learn something today newly.