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
amitchandak
Super User
Super Userkest874 , 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