Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
Hi,
Share some data and show the expected result.
Thanks.It Worked
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.