Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
21 | |
18 | |
14 | |
11 |
User | Count |
---|---|
44 | |
35 | |
25 | |
22 | |
22 |