How to pick just top 3 When Rank is same

[Anonymous]

Hi Guys Does Anyone know How to pick just Top 3 When We have the Rank or Same Values for top Values.

VAR __Data1 =

VALUES(Lead_Performence[RMName])

VAR __TopLeads =

TOPN(

3,

ALL(Lead_Performence[RMName]),

[Total Leads],

DESC

)

VAR __Top3 =

CALCULATE(

[RM Accep. %],

TOPN(

3,

ALL(Lead_Performence[RMName]),

[RM Accep. %],

DESC

),__Data1

)

RETURN

__Top3

[Mahesh0016 · Accepted solution]

@Anonymous https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

*If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

[johnt75]

You would need to use another column or measure as a tie breaker. The TOPN function accepts multiple ranking parameters, so you just need to decide how you want to determine what is in the top 3 - alphabetical, most recent, earliest etc. If you don't have a column which uniquely defines a row then you could add an index column using Power Query.