Applying Pareto Analysis 3 times for classifying Customers

Shahvaladi — Sun, 16 Jul 2023 08:02:42 GMT

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.

Re: Applying Pareto Analysis 3 times for classifying Customers

gregoliveira — Sun, 16 Jul 2023 08:22:06 GMT

Hi.