Display difference in measure by category

alsm — Wed, 08 Nov 2023 11:42:06 GMT

My data looks like

I am displaying line chart

where measure Total is combination of two other measures

Total = [A_D] + [L_D]

where

A_D = CALCULATE(SUM(data2[Income]),data2[Level]="A" || data2[Level]="D") L_D = CALCULATE(SUM(data2[Income]),data2[Level]="L" || data2[Level]="D")

In Legend I have scenario (which creates 3 lines)

Base, Down, Up

and I see values of 'Total' in tooltip

I additionally want to show

Base - Down in tooltip

I cannot create a measure that works like

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

i.e. Sum([Total]) ie. sum of measure is not allowed.

Any ideas how to implement this?

full data series in chart

Re: Display difference in measure by category

eliasayyy — Wed, 08 Nov 2023 12:06:26 GMT

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

Dangar332 — Wed, 08 Nov 2023 12:15:26 GMT

Hi, alsm

tyr below

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

alsm — Wed, 08 Nov 2023 13:11:10 GMT

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

alsm — Wed, 08 Nov 2023 13:12:44 GMT

Thank you for your reply.

learning: "to add measures with filter one needs to use sumx and for adding columns sum would suffice"

Dangar332 — Wed, 08 Nov 2023 13:21:38 GMT

Hi, alsm

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