Forum Discussion
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?...
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() )
Greg_Deckler
Community Champion
Community ChampionI'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