cancel
Showing results for
Did you mean:
Frequent Visitor

## 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 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.

1 ACCEPTED SOLUTION
Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
7 REPLIES 7
Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

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

Thanks!

Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

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!!

Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

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

Proud to be a Super User!

Frequent Visitor

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!

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors