Latest Enterprise DNA Initiatives

Pareto Rule - DAX Function

Hey Fellow Power BI Users -

Just looking at your example online.
Just curious as to why I have a static total. I feel this is the exact same as yours too, but your number updates to Top 20…
I DAX also seem the same as yours too, or is it me ?

You seem to be using a different formula.

This one below works fine in the example

Sales of Top 20% of Customers =

CustomerPercent = DISTINCTCOUNT( Sales[Customer ID] ) * 0.2

CALCULATE( [Total Sales],
     FILTER( VALUES( Sales[Customer ID] ),
          RANKX( VALUES( Sales[Customer ID] ), [Total Sales], , DESC ) <= CustomerPercent ))

Hi Sam

The below video you show a different technique as this below way I can see the 20% of my customers.
I can drag this measure and see it based on my customers.

However i’ve used exactly same format of DAX as you, and my total itself is wrong

So Sam
Just confirming doing a Pareto this way, I am just confused because I am not sure this actually shows who exactly are the 20% of the customers are. If i dragged below measure on my customer field it goes blank.
Hence why I am trying to use a DAX like in my 2nd screen shot.

Thanks in advance.


Ok sorry, understood now.

Try this formula below, I’ve optimized it for this

Top 20% Customer = 
VAR CustomerRank = RANKX( ALL( Customers ), [Total Sales], , DESC )
VAR UniqueCustomers =  CALCULATE( [Unique Customers], ALL( Customers ) )
VAR Top20 = UniqueCustomers * 0.2

IF( ISFILTERED( Customers[Customer Name] ),
    IF( CustomerRank < Top20, [Total Sales], BLANK() ),
        CALCULATE( [Total Sales], TOPN( Top20, ALL( Customers ), [Total Sales], DESC ) ) )

1 Like

Hi everyone,
I’ve been working on how to solve the problem with the pareto here where 2 or more values are equal. Like this ranking here, there are 2 rows with the same rank, = 6. How can i fix that? How did you fix it?

Hi @mariam_khalid,
Please start a new topic as this as the string is already solved. Your question might get lost and won’t be answered.


1 Like