Cumulative total sales %

[Migsmix]

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 file you can see the table and how should it look. In this example, 13 of my products make the 80% of my past 12 months sales. Also, i should be able to filter by zone, brand, type, etc and show me how many products make the 80% of my sales. 

Thanks! Here is the attached file. 

[Ashish_Mathur]

Hi,

On what basis have you decided the order in which the rows have to be sorted?  Do they have to be sorted by the Content column in ascending order?  This is important to know because the numbers in the Cumulative column will depend on that.

[Migsmix]

Hello @Ashish_Mathur , it should be sorted ascended by sales past 12 months.

Thanks!

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Migsmix]

Thank you @Ashish_Mathur . If i want to filter by zone so the table shows me the cumulative sales only of the products in the zone "start", how can i do that? 

thanks!!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[ryan_mayu]

@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]

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!