Forum Discussion
Cumulative Sum without repeat value
Hello PowerBi communauty, I did a measure DAX to cumulative sum, but when I created a plot scatter it looks like I have all "price" again at the end of the visual. I have double plots..Can you help...
Hi Anonymous ,
In addition to what FBergamaschi said, you could try using a visual calculation with RUNNINGSUM. Here is additional information:
https://www.youtube.com/watch?v=pqfBH0ZmYkA
CumulativeVolumeDescending =
VAR CurrentPrice = SELECTEDVALUE('Sheet'[price])
RETURN
SUMX (
FILTER (
ALLSELECTED('Sheet'),
'Sheet'[price] >= CurrentPrice
),
[Volume]
)
use this
Instead of <= CurrentPrice, we use >= CurrentPrice to accumulate volumes from higher prices down to the current one.
Yes, I alrealdy did it. But it shows that..like the original issue...