cancel
Showing results for
Search instead for
Did you mean:
Sachy123 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 Super User

## 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 New Contributor

## Re: Cumulative total for a simple table

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

## 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

## Re: Cumulative total for a simple table

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

## Helpful resources

Announcements
Top Ideas Top Kudoed Authors
Users Online
Currently online: 100 members 1,682 guests
Recent signins:
• Talaal-Sid • dnavia • OwenAuger • pballew0 • • rexii23 • mussaenda Please welcome our newest community members:
• philpunter • thaoha • eebustamante • CVianello • andrewpp • barrychen0825 • kip88 