TOP N not working

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.

Sure

If [Dirver Number] = 0 or [Driver Number] = BLANK() ignore the row in the ranking.

Otherwise rank the drivers based on [Avg Score] * [Response Count].

Basically, if two drivers have the same average score rank the one with more responses higher.

cham 

You can apply a filter to a visual of TopN based on a measure.  For ranking you want to do it in BottomN so it will go from lowets (1, which is the best rank) up.

Not sure what you mean about country, can you share your data including the country and show the problem and expected result?

cham 

There are 25 drivers in Canada all with N = 100.  Which 20 of those do you want?

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?

Hi jdbuchanan71 ,

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

Hey jdbuchanan71 ,

smart move!

Hi jdbuchanan71 

Cant we put rank the drivers based on [N]? 

Also if I add the coutry into it numbers are getting increase. Why is that? 

Hi jdbuchanan71 ,

https://drive.google.com/file/d/10a5XQYojfl9c-4unh1ZBbmDNs9E2ekh5/view?usp=sharing

Please find the above link to access the file. I want to show Top 20 "N" value accoding to the drive and the country. 

I am confusing why you create a response count aand ave score for this? I want to get top 20 drivers in countries which show top 20 "N values"

Hope this explain you my question. 

Hi jdbuchanan71 

I have added a resposes field that now you can filter it. Please check the updated file.

Hi jdbuchanan71 

Did you find any way to solve this? Can you please help me with this?

Hi jdbuchanan71 

Thank you so much for your help. Appreciate it :)