Applying Pareto Analysis 3 times for classifying Customers

[Shahvaladi]

hello friends,

I want to do classification on my customers based on pareto rule but in my own way.

My Classes Are : A+ , A , B and C

For emxample, I have total number of 1000 customers summrized by their Sales Amount.

I want to do pareto Analysis 3 times to group my customers like below :

For example :

Step 1 : 1000 customer  : 80% of Sales (400 Customers)-----20% of Sales (600 Customers) So  600 customers = Class C

Step 2 : 400 customer  :   80% of Sales (250 Customers)-----20% of Sales (150 Customers) So 150 customers = Class B

Step 3 : 250 customer  :   80% of Sales (80   Customers)-----20% of Sales (170 Customers) So 170 customers = Class A

and 80 Customers A+ Class.

It would be appretiated if you guys help me do this either in Powerpivot using dax or Power Bi.

So that I could have the list of each customers and dynamically filter through different categories in my data model.

[gregoliveira]

Hi.

Take a look in this article from SQLBI team (https://www.daxpatterns.com/abc-classification/).