Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Running total based on ranking index

Hi all!    I'm looking for a way to calculate a Running total. So from what I read before, I tried to create a Ranking index with this formula: Rank = RANKX(ALLSELECTED(Division[Product code]),CA...
DAX
Help me please
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a new measure like

 

SUMX( ADDCOLUMNS(
SUMMARIZE( Division, Division[Product code],
"Sales" , Sales[Sales (kg)],
"Sales Ranking" , RANKX( ALL(Division) , [Sales (kg)], , ASC) ),
"Cumm" , calculate(sum([Sales]), filter( Division, [Sales Ranking] <= max([Sales Ranking]) ))),
[Cumm] )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak ,

 

Thanks for the quick reply.

 

It is not working as I need my Rank to be a measure and not a column because I have a lot of datas (the table here is just a filtered example of my datas) and I need this ranking to be dynamic as I am filtering on date, types of products and many other fields so the only way of doing this is with a measure and Max function only accepts a column reference.

 

Do you know another way of doing this with Ranking being a measure ?

Thanksss