topic Re: How to pick just top 3 When Rank is same in DAX Commands and Tips

How to pick just top 3 When Rank is same

Anonymous — Mon, 09 Jan 2023 09:58:13 GMT

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(

ALL(Lead_Performence[RMName]),

[Total Leads],

DESC

)

VAR __Top3 =

CALCULATE(

[RM Accep. %],

TOPN(

ALL(Lead_Performence[RMName]),

[RM Accep. %],

DESC

),__Data1

)

RETURN

__Top3

Re: How to pick just top 3 When Rank is same

johnt75 — Mon, 09 Jan 2023 10:12:21 GMT

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.

Re: How to pick just top 3 When Rank is same

Mahesh0016 — Mon, 09 Jan 2023 10:18:25 GMT

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.