Forum Discussion
Solved
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.
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.
Hi Ashish_Mathur ,
I have a Driver No field with another measure I want to get top 5 drivers according to that measure. How can I get that?