Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Shahvaladi
New Member

Applying Pareto Analysis 3 times for classifying Customers

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.

 

Class.png

1 REPLY 1
gregoliveira
Helper II
Helper II

Hi.

 

Take a look in this article from SQLBI team (https://www.daxpatterns.com/abc-classification/).

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.