Rank one by one

Well, this will almost certainly involve a RANKX measure:

https://msdn.microsoft.com/en-us/library/gg492185.aspx

You may have to do something like use TOPN to seed your RANKX and sort in decreasing order perhaps so that 1 is 5 and 5 is 1 so that you could use your rank in the manner you described in a stacked column chart:

https://msdn.microsoft.com/en-us/library/gg492198.aspx

Ababneh

Follow the below steps

Create 2 Mesures

Scores = CALCULATE(SUM(Table1[Score]))

Then Rank Measures

Ranking = RANKX ( ALL ( Table1[Name]), [Scores],,DESC,Dense)

to Filter top 5 use this measure

Top 5 Name = 
IF( HASONEVALUE( 'Table1'[Name]) ,
	IF ( 
	[Ranking] <= 5 ,
		[Ranking] , 
			BLANK()
	)
)

& filter it as "is not Blank" from visual level filters

Regards,

Chetan K

Hi Ababneh,

I think the column ID is unique though there are duplicates 3142. And the ID should be unique. If so, it's easy to find the top 5.

1. In Query Editor, sort "Score" by Desc and sort "Times Tried" by Asc;

2. Add an index from 1 and change the column into "Order". Then the rank is ready;

3. Set ID sort by "Order";

4. Create a visual "Funnel" and set field as the picture showed. 

Best Regards!

Dale