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.
Hello,
Let's say that I have a table like that :
Index Value
1 90
2 120
3 140
4 150
In the visualisation, I am making a slicer with Indexes (so I can choose from 1 to 4)
What I want to do, is when I select 3, I am calculating the sum of all values below and including 3 (in the example it would be 90+120+140).
Any solutions? I was trying various calculate() + filter() options, but none of them worked correctly.
Solved! Go to Solution.
Hello, @pejczi
Please, try this formula:
Cumulative Total =
CALCULATE (
SUM ( Table[Value] ),
FILTER ( ALL ( Table[Index] ), Table[Index] <= MAX ( Table[Index] ) )
)
I want to collaborate with my code that fetches the remaining value (sum) by the previous index.
Create column
And
Create a measure
Hello, @pejczi
Please, try this formula:
Cumulative Total =
CALCULATE (
SUM ( Table[Value] ),
FILTER ( ALL ( Table[Index] ), Table[Index] <= MAX ( Table[Index] ) )
)
Thank you, it works after adjusting to my case (some of features stopped working, but I need to adjust relations a little bit, but generally it is okay :-))
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 |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |