80/20 rule

Question

Hi,&nbsp;i am trying to find the customer count that they are doing the 80% of sales for a specific period.&nbsp;Can you help me on this?&nbsp;Thanks,&nbsp;Haris&nbsp;

anonymous · Answer

Without more information it is hard to help you. Can you show us the model?
&nbsp;
80% of sales amount? Ordered by what?&nbsp;

amitchandak · Answer

refer:
https://community.powerbi.com/t5/Desktop/count-number-of-vendors-in-the-top-80-revenue/td-p/478212

hadjigeo · Answer

HiAnonymous&nbsp;&nbsp;Below you will find an example that i did.I need to get the number of customers that they did the 80% of the total sales.so for the below example:Total Sales: 3.3M80% of Revenue is 2.7MCustomers that they did the 80% of Sales are 12 customers.so i need to find a way to calculate the customers that they did the 80% of Sales.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hope that i gave your all the details.&nbsp;Thanks,&nbsp;Haris&nbsp;

anonymous · Answer

This is classic client's classification:
https://www.daxpatterns.com/abc-classification/
&nbsp;
&nbsp;

Forum Discussion

80/20 rule

4 Replies

Related content

80-20 distribution of data

Pareto 80/20 calculation for items making up 80% of Sales

80%-20% pie chart

Pareto (80/20) Segmentation

Recalculation on 80/20 based on slicer choices