Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 :-))
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |