Forum Discussion
Solved
Top 10 does not work correctly
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. ...
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
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
