dax for top 5

[Anonymous]

Hi

i am looking for dax to display top 5 place names based on request. i dont want to use top n filter bcoz it will not consider the reappearing requests.

expected top 5

Nenagh      19
Donegal      15
carlow         13
enniscorthy 13
ballyowen   12

[ManojRajendran]

I got a scenario where I need to show top 5 category sales in one visual and in another visual I need to show other categories which are not in top 5 of the previous visual. Please suggest.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[suparnababu7]

Thanks.It Worked

[Ashish_Mathur · Accepted solution]

Hi,

To your visual drag Store and this measure

Top 5 stores = calculate([request],TOPN(5,ALL(Data[Store]),[request]),values(Data[Store]))

Hope this helps.