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, 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])))
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. 

3 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    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. 

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

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

  • 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])))