Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
31 | |
27 | |
15 | |
13 | |
10 |