Forum Discussion

cham's avatar
cham
Post Patron
6 years ago
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?       
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

It works fine for me.  See the screenshot.

cham's avatar
cham
Post Patron
6 years ago

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?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    Share the link from where i can download your PBI file.  In the file, clearly show your expected result.

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User
      6 years ago

      You could take into account the number of responses along with the avg score to get a ranking.  I have added the calc and adjusted the matrix to give you an idea of what I had in mind.

      • cham's avatar
        cham
        Post Patron
        6 years ago

        Hi jdbuchanan71 ,

         

        Can you please explain me the measure you used for calculate the ranking?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      The value of N for more than 20 drivers is the same.  Perhaps this is the reason for the TopN not working.  Considering more then 20 drivers have the same value of N i.e. 100, what result do you expect to see?