Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 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!

 

6 Replies

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    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. 
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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: