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.
Try below measure,
I can't add an attachment to the message.
But here is some data:
The result should be: