Forum Discussion
RANKX + Others without calculated column
Hi, I have seen a lots of topics talking about it, but every time, it was about creating new tables or calculated columns ; I cannot. I use DirectQuery mode, and I want to have a pie chart with ...
Try below measure,
Rank =
var a =RANKX(ALLSELECTED(Table1[Customer]),[Sales],,DESC,Dense)
var b =5 (As you want top 5 you can make it dynamic also.... top N customers)
return
if(a<=b,1,0)
And add it in visual level filter and set is not 0.
This will give you top 5 Customers without creating any Column.
Thank you for your answer Anonymous.
Will it gives me the "others" category?