Cumulative total for a simple table

[Sachy123]

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, 1001, 1001001 

So I added the following measure.. but it seems not be working - Can somoene please help!

RunningTotal = CALCULATE(Sum(Scale[Scale]),FILTER(Scale,Scale[Scale]<=VALUE(Scale[Scale])))

[jdbuchanan71 · Accepted solution]

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. 

[Sachy123]

I was just not able to refer to the current row-- thanks for this tip

[HotChilli]

RunningTotal = CALCULATE(Sum(Scale[Scale]),FILTER(ALL(Scale), Scale[Scale] <= MAX(Scale[Scale])))