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

The 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.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Kudoed Authors