Forum Discussion

Sachy123's avatar
Sachy123
Icon for Helper V rankHelper V
7 years ago
Solved

Cumulative total for a simple table

I have following simple table :   Scale = DATATABLE("Scale",INTEGER,{{1},{1000},{1000000}})   Now , I just want to add one more column to it , so that I can get a cumulative sum like 1, 10...
Need Help
Show and Tell
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    Hello Sachy123 ,

    We just need to feed it the current row in a variable and use it to filter our sum:

    Running Total = 
VAR RowScale = Scale[Scale]
RETURN
    CALCULATE ( 
        SUM ( Scale[Scale] ),
        Scale[Scale] <= RowScale
    )

    *Removed the unneeded filter. 

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago
RunningTotal = CALCULATE(Sum(Scale[Scale]),FILTER(ALL(Scale), Scale[Scale] <= MAX(Scale[Scale])))