HELP: RANKX Function

[sam1220]

So I have a table that shows countries. Now I want to get the top 3 countries that are most common in the column.

So I decided to play around with RANKX, seen multiple threads. Most 'helpful' one is http://community.powerbi.com/t5/Desktop/Ranking-Subjects/m-p/21663#M6731 this one. However, as you can see in the table, all it shows is rank number one.

What I've done in cc is COUNTA column. But in the rank column is this:

Measure:                   Measure = COUNT(Table1[Countries])

Rank Column:           Rank = RANKX(ALLSELECTED(Table1), [Measure])

Any help is appreciated!

[BhaveshPatel · Accepted solution]

You can use this two measures for the ranking of the countries:

Total Rows:=COUNTROWS(Table1)

Top Countries := RANKX(ALL(Table1),[Total Rows],,,Dense)

[sam1220]

Yep, added the measure to the visual filter. Worked like charm. Sorting works great too! Thanks for the help