cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sachy123 Regular Visitor
Regular Visitor

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, 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])))
1 ACCEPTED SOLUTION

Accepted Solutions
jdbuchanan71 New Contributor
New Contributor

Re: Cumulative total for a simple table

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. 

3 REPLIES 3
HotChilli Senior Member
Senior Member

Re: Cumulative total for a simple table

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

Re: Cumulative total for a simple table

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 Regular Visitor
Regular Visitor

Re: Cumulative total for a simple table

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