Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/05/2023 | Down | A | 59,107 |
31/05/2023 | Down | D | 9,179 |
31/05/2023 | Down | L | 81 |
31/05/2023 | Up | A | 57,808 |
31/05/2023 | Up | D | 7,698 |
31/05/2023 | Up | L | 1,142 |
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
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/05/2023 | Down | A | 59,107 |
31/05/2023 | Down | D | 9,179 |
31/05/2023 | Down | L | 81 |
31/05/2023 | Up | A | 57,808 |
31/05/2023 | Up | D | 7,698 |
31/05/2023 | Up | L | 1,142 |
30/06/2023 | Base | A | 61,400 |
30/06/2023 | Base | D | 4,721 |
30/06/2023 | Base | L | 620 |
30/06/2023 | Down | A | 61,954 |
30/06/2023 | Down | D | 7,279 |
30/06/2023 | Down | L | 146 |
30/06/2023 | Up | A | 60,527 |
30/06/2023 | Up | D | 3,278 |
30/06/2023 | Up | L | 1,380 |
31/07/2023 | Base | A | 60,247 |
31/07/2023 | Base | D | 6,636 |
31/07/2023 | Base | L | 573 |
31/07/2023 | Down | A | 60,700 |
31/07/2023 | Down | D | 9,504 |
31/07/2023 | Down | L | 116 |
31/07/2023 | Up | A | 59,479 |
31/07/2023 | Up | D | 4,871 |
31/07/2023 | Up | L | 1,320 |
31/08/2023 | Base | A | 60,755 |
31/08/2023 | Base | D | 6,217 |
31/08/2023 | Base | L | 535 |
31/08/2023 | Down | A | 61,205 |
31/08/2023 | Down | D | 8,940 |
31/08/2023 | Down | L | 91 |
31/08/2023 | Up | A | 59,982 |
31/08/2023 | Up | D | 4,586 |
31/08/2023 | Up | L | 1,270 |
30/09/2023 | Base | A | 64,755 |
30/09/2023 | Base | D | 7,389 |
30/09/2023 | Base | L | 593 |
30/09/2023 | Down | A | 65,222 |
30/09/2023 | Down | D | 10,356 |
30/09/2023 | Down | L | 113 |
30/09/2023 | Up | A | 63,967 |
30/09/2023 | Up | D | 5,539 |
30/09/2023 | Up | L | 1,372 |
Solved! Go to Solution.
hello it seems that you are trying to sum a measure, you are using the wrong syntax pelase try sumx instead of sum
Hi, @alsm
tyr below
result =
Calculate(Sumx(data2,[output]), data2[Scenario]="Base") - Calculate(Sumx(data2,[output]),
data2[Scenario]="Down")
Hi, @alsm
tyr below
result =
Calculate(Sumx(data2,[output]), data2[Scenario]="Base") - Calculate(Sumx(data2,[output]),
data2[Scenario]="Down")
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
Hi, @alsm
no problem but your measure [total] is saved by me as a name [output] so i mention output as a measure name
hello it seems that you are trying to sum a measure, you are using the wrong syntax pelase try sumx instead of sum
Hi @eliasayyy
Thank you for your reply.
learning: "to add measures with filter one needs to use sumx and for adding columns sum would suffice"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
51 | |
47 | |
16 | |
13 |