Forum Discussion
Column and line chart - filter every one seperately
- 6 years ago
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()) - 6 years ago
Create 2 measures:
Measure 1 = SUMX(FILTER('Table',[actual/planned] = "planned"),[Profit])
Measure 2 = SUMX(FILTER('Table',[actual/planned] = "actual"),[Profit])
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())