Forum Discussion
TOP N not working
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.
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.
I tried TOP N but its not working that's why I asked it from community.
I used below two column in my report ,
Driver No Amount 12 9876 14 2345 13 1234 12 4456 12 3221 12 1111 15 23345 15 3456 12 22224 12 1234 16 2214 16 1111 16 3345 Hi,
It works fine for me. See the screenshot.