Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TATUPOCCARD
New Member

How to calculate what percentage of customers account for 80% of the expenditure.

Hello! I have a table with the following data:

  1. Customer code
  2. Brand
  3. Gauge
  4. Total volume sold
  5. Total spending

I want to know how to calculate what percentage of customers (those with a volume greater than 0) account for 80% of the total spending. In other words, an 80/20 Pareto analysis.

Thank you!

1 ACCEPTED SOLUTION
ERD
Super User
Super User

Hi @TATUPOCCARD , try this: https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/ 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!


Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

View solution in original post

2 REPLIES 2
ERD
Super User
Super User

Hi @TATUPOCCARD , try this: https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/ 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!


Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

Thank u for the response! I may have expressed myself poorly, but I don't want to fix that 20%. I need to know what % of customers account for 80% of the spending. In other words, perhaps for one brand, 100 out of the 200 customers do this (50%), but for another, only 50 out of the 5000 do (10%). What I want to find out is those 100 or 50 customers in each example.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors