Calculated Table Cumulative TOtal

[czuniga]

I'm trying to add a column with a cumulative total in a calculatedtable with this DAX: 

CALCULATE(sum('Eighty20'[LTV]), FILTER( ALLSELECTED( Eighty20 ), Eighty20[Rank Asc] <= MAX (Eighty20[Rank Asc])))

but I'm getting the overall sum in each field rather than the cumulative total. Any ideas as to why?

[az38 · Accepted solution]

Hi @czuniga 

replace MAX() to EARLIER()

[czuniga]

THANK YOU!