RANKX + Others without calculated column

[Anonymous]

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 Top 5 turnover and "Others" category represented.

I hope to have not missed the right topic, but here is this one.

I already have a rank measure which ranks the cities by turnover.

Thank you.

[Anonymous]

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.

[Anonymous]

Thank you for your answer @Anonymous.

Will it gives me the "others" category?

[Anonymous]

share your sample dataset.

[Anonymous]

sorry it will not show others. let me try for others

[Anonymous]

I can't add an attachment to the message.

But here is some data:

Country	Turnover
USA	100
CANADA	200
AUSTRALIA	300
GERMANY	100
RUSSIA	500
LITHUANIA	600
UKRAINE	400

The result should be:

[Anonymous]

without column in not possible. you need to create calculated column.

[Anonymous]

Ok so no solution for me 😔 as I cannot create calculated columns.