Forum Discussion
Solved
Top 1 name by location
Hello,
I'm attmpting to get the top 1 submitter by location:
I've attempted the top n filters on name but it only returns 1. I expect to see 6 names total.
Any guidance?
kest874 , Create a rank like this and filter =1 at visual level filter
rankx(allselected(Table[location]), [submitted],,desc,dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
2 Replies
- amitchandak
Super User
kest874 , Create a rank like this and filter =1 at visual level filter
rankx(allselected(Table[location]), [submitted],,desc,dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures Awesome thank you I knew it had to be something simple.
