Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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