Top 10 does not work correctly

[A_Barny]

Hi everyone,

I have a problem on my mesure and I don't know why. I try to do a TOP10 of YTD quantity by Customers.  I want the TOP 9 Customers and the last will be the "Others" customers.

For do that, I did 2 mesures :

Mesure = RANKX(ALL('A - Dimensions'[Customer DO - ABC]);'D - YTD Measures'[YTD Qty])

and 

top 10 = IF('A - Dimensions'[Mesure]<10; 'A - Dimensions'[Customer DO - ABC] ;"Top Others")

When I try validate my last mesures my computer crash because this resquest need to do many calculate but I don't understand why.

Exemple of Data :

Customers	YTD Qty	Mesure		TOP 10
Customers 3	399	1		1
Customers 5	389	2		2
Customers 1	350	3		3
Customers 2	260	4		4
Customers 4	234	5		5
Customers 10	222	6		6
Customers 15	200	7		7
Customers 12	157	8		8
Customers 10	156	9	-->	9
Customers 6	148	10		Others
Customers 8	100	11		Others
Customers 13	99	12		Others
Customers 9	49	13		Others
Customers 14	29	14		Others
Customers 11	2	15		Others

This is what I try to do with the name of others customers too :

Can you help me to understand it and fix it ?

Thanks a lot,

Alex

[v-shex-msft · Accepted solution]

HI @A_Barny,

You can add new calculate to replace top 10 values, then use new column as category.

Category = IF([TOP 10]<>"Others",[Customers],[TOP 10])

Regards,

Xiaoxin Sheng

[Greg_Deckler]

Do you have some sample data you can share? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[A_Barny]

I added modifications on the first post

[A_Barny]

Anyone have idea ?