Forum Discussion

alsm's avatar
alsm
Icon for Helper III rankHelper III
2 years ago
Solved

Display difference in measure by category

My data looks like Date Scenario Level  Income  31/05/2023 Base A              58,619 31/05/2023 Base D                 7,914 31/05/2023 Base L                    471 31/0...
  • eliasayyy's avatar
    eliasayyy
    2 years ago

    hello it seems that you are trying to sum a measure, you are using the wrong syntax pelase try sumx instead of sum

  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, alsm 

    tyr below

    result =
  Calculate(Sumx(data2,[output]), data2[Scenario]="Base") - Calculate(Sumx(data2,[output]), 
  data2[Scenario]="Down")
alsm's avatar
alsm
Icon for Helper III rankHelper III
2 years ago

Hi Dangar332 ,

cosmetic edit to your solution

result =
  Calculate(Sumx(data2,[Total]), data2[Scenario]="Base") - Calculate(Sumx(data2,[Total]), 
  data2[Scenario]="Down")

the measure I want to add is Total (and not output)

 

Thank you for your reply

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, alsm 

no problem but your measure [total]  is saved by me as a  name [output] so i mention output as a measure name