Forum Discussion

Migsmix's avatar
Migsmix
Frequent Visitor
4 years ago
Solved

Cumulative total sales %

Hi!   I'm struggling calculating the cumulative sales % for my products. Basically i want to do a pareto analysis so i know the number of products that give me the 80% of my sales. In the attached ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

Migsmix 

is this what you want?

Measure = sumx(FILTER(all('Table'),'Table'[Content]<=max('Table'[Content])),'Table'[Sales Past 12 months])

Measure 2 = [Measure]/CALCULATE(sum('Table'[Sales Past 12 months]),all('Table'))

pls see the attachment below

Migsmix's avatar
Migsmix
Frequent Visitor
4 years ago

Hello ryan_mayu , the table should be sorted ascendent by sales past 12 months. Also, if i use a filter like brand, type or zone, the table should be recalculated to show those products that make de 80% of the sales in the brand "Font" or Zone "Final". With this i can see the number of products that make de 80% of the past 12 sales and also see the which products are.

 

Thanks!

 

Thanks!