Forum Discussion
Field Parameters Difference Total
Hi All, just asking for help on how can I create a Total but instead of sum it should be difference of the two selected measure in the Field Parameters. See below and attached sample PBI file on how ...
Anonymous
You need to hide the non total [Difference] column(s) manually.
Hi, not sure if this is possible, the top most what i could achieve is something like that
you just create a switch measure =
SwitchMeasure = SWITCH(min('Right Table'[Right Table Order]),
0, [2 Revenue],
1, [2 Cost],
2, [2 Gross])
Every measure with 1 you have to remake like this:
1 Cost = if(isfiltered(test_data[Month]), SUM(test_data[Cost]), SUM(test_data[Cost])-[SwitchMeasure])
Every Measure with 2.
Every Measure with 2.
if(isfiltered(test_data[Month]), SUM(test_data[Revenue]))
Afterwards depending on your data may be you can play how to hide that column in the end.
Afterwards depending on your data may be you can play how to hide that column in the end.
Thank you olgad