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.
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?
Hi,
Share the link from where i can download your PBI file. In the file, clearly show your expected result.