How can I get the top 10 performers (only 10 rows) from a table only by using DAX for duplicate rows

[MSirfan]

Employee Name	ratings
A	5
B	5
C	5
D	5
E	5
F	5
G	5
H	4
I	4
J	5
K	5
L	4
M	5

The Output should be

Employee Name	ratings
A	5
B	5
C	5
D	5
E	5
F	5
G	5
J	5
K	5
M	5

[lbendlin · Accepted solution]

Has to be a calculated table, not a measure.

[talespin · Accepted solution]

hi @MSirfan 

Assumption : Employee will not be repeated, need to pass unique ID.

Rank Emp =

RANK(DENSE, ALL(Table3), ORDERBY(Table3[Nameratings], DESC, Table3[Employee], ASC))

[lbendlin · Accepted solution]

Has to be a calculated table, not a measure.

[lbendlin]

TOPN(10, Table, NameRatings, DESC)

Note this will not be deterministic even if you specify how to handle ties.

[MSirfan]

We can't pass a column without using aggregation function in Topn function because it's takes only a single scalar value

[lbendlin]

I'm not following. 

[MSirfan]

i am getting this error