80/20 rule

[hadjigeo]

Hi,

i am trying to find the customer count that they are doing the 80% of sales for a specific period.

Can you help me on this?

Thanks,

Haris

[amitchandak]

refer:

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

[Anonymous]

Without more information it is hard to help you. Can you show us the model?

80% of sales amount? Ordered by what? 

[hadjigeo]

Hi

@Anonymous 

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.3M

80% of Revenue is 2.7M

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

Hope that i gave your all the details.

Thanks,

Haris

[Anonymous]

This is classic client's classification:

https://www.daxpatterns.com/abc-classification/