topic Field Parameters Difference Total in DAX Commands and Tips

Field Parameters Difference Total

Anonymous — Thu, 01 Jun 2023 03:59:38 GMT

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!

Re: Field Parameters Difference Total

tamerj1 — Thu, 01 Jun 2023 07:48:31 GMT

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

Re: Field Parameters Difference Total

Anonymous — Thu, 01 Jun 2023 07:59:06 GMT

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:

Re: Field Parameters Difference Total

olgad — Thu, 01 Jun 2023 09:30:01 GMT

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.

Re: Field Parameters Difference Total

tamerj1 — Thu, 01 Jun 2023 09:48:50 GMT

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

Re: Field Parameters Difference Total

Anonymous — Thu, 01 Jun 2023 23:27:12 GMT

Awesome this works! Thank you!

Re: Field Parameters Difference Total

Anonymous — Thu, 01 Jun 2023 23:27:54 GMT

Thank you olgad