Forum Discussion
TOP N not working
Hi,
I want to get the TOP 5 driver numbers according to the amount. I tried it as below but its not working. Can anyone help me to do this?
Hello cham
I believe I did find a way to solve this. I had to add a drivers table to use as a anchor for the rankings.
The udpated file is attached.
21 Replies
Hi,
Try these measures
Total value = SUM(Table[Amount])
Rank by Driver = RANKX(ALL(Table[Driver]),[Total value])
Drag Driver and Total value measure to your visual. Filter the second measure on Less than equal to 5.
Hope this helps.
Hi,
What you mean by Filter the second measure on Less than equal to 5?
See the below pic. Cannt we use TOP N filter to do this?
Yes, The TopN should also work. Try it. If it does not, then share the link from where i can download your PBI file.
