Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

cumulative sum without date

Hi! I need to identify the most sold products which represent 80% of my sales. For instance:   PRODUCT           SALES           CUMULATIVE SALES A                           50                    ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    Cumulative is based on the sort order , You can sort on sales

    Cumm1 = CALCULATE(sum('product'[SALES]),FILTER(all('product'),'product'[SALES]>=MAX('product'[SALES])))

     

    Better you create a dense rank and use that. New column

    rank = ranks(all(Product),Product[sales],,asc,dense)

     

    Use rank in last formula

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

Cumulative is based on the sort order , You can sort on sales

Cumm1 = CALCULATE(sum('product'[SALES]),FILTER(all('product'),'product'[SALES]>=MAX('product'[SALES])))

 

Better you create a dense rank and use that. New column

rank = ranks(all(Product),Product[sales],,asc,dense)

 

Use rank in last formula

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak This is the measure I was looking for!

 

Cumm1 = CALCULATE(sum('product'[SALES]),FILTER(all('product'),'product'[SALES]>=MAX('product'[SALES])))

 

Thanks a million!