Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
14 | |
12 | |
12 | |
9 |
User | Count |
---|---|
63 | |
22 | |
21 | |
17 | |
11 |