Forum Discussion
Column and line chart - filter every one seperately
Hey Power Bi Guys! I have my data like this: Month Profit actual/planned 1 5000 planned 2 3000 planned 3 4000 planned 4 2000 planned … … … 1 2000 actual 2...
Anonymous , Did not get completely
But this should work as measure
planned=calculate(sum(table[profit]), table[actual/planned]="planned")
actual=calculate(sum(table[profit]), table[actual/planned]="actual")and these a new columns
planned=if( table[actual/planned]="planned",table[profit], blank())
actual= if( table[actual/planned]="actual",table[profit], blank())Create 2 measures:
Measure 1 = SUMX(FILTER('Table',[actual/planned] = "planned"),[Profit])
Measure 2 = SUMX(FILTER('Table',[actual/planned] = "actual"),[Profit])
