Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |