Cumulative Sum of a column

[ahsanlhcgov]

Hi Everyone, 

I am trying to create a new column that shows cumulative sum of the levy amount. 

Please can someone assist me in doing this. 

[v-chuncz-msft]

@ahsanlhcgov,

You may use Quick measure Running total.

[ahsanlhcgov]

@v-chuncz-msft

the quick measure is not loading any options for me. probably the dataset is too big for it work through it. 

I left it overnight but in the morning it still did not give me any options. 

is there anyway I can use DAX to fix this issue. 

[Zubair_Muhammad · Accepted solution]

@ahsanlhcgov

Try this as a MEASURE

MEASURE =
CALCULATE (
    SUM ( TableName[Levy Amount] ),
    FILTER (
        ALL ( TableName ),
        TableName[MonthDTAdded] <= SELECTEDVALUE ( TableName[MonthDTAdded] )
    )
)