Field Parameters Difference Total

[krixtsup3r]

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 it looks like:

Here is the download link for the sample pbix file: https://www.dropbox.com/s/6qrb5seyty1d2l4/sample.pbix?dl=0

Thank you so much for the help!

[olgad]

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. 

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. 

[krixtsup3r]

Thank you @olgad 

[tamerj1]

Hi @krixtsup3r 
Please refer to attached sample file with the proposed solution.

[krixtsup3r]

Thank you @tamerj1!

Also, what if I selected more than 2 months in it? What it should do actually is add the 3 months for both parameters and then do the difference.

The output should be like this:

[tamerj1 · Accepted solution]

@krixtsup3r 
You need to hide the non total [Difference] column(s) manually.

[krixtsup3r]

Awesome this works! Thank you!