Top Name with count

[Anonymous]

Hi,

I'm trying to find the top partner name from the table below. 'Top' as in most leads, so I'm counting the leads per partner and wanting to return the name of the partner with the most leads.

I'm getting an error with the below code 'cannot convert value 'Tom' of type text to type true/false'.

I'd also like to be able to find the second best partner name as a separate query. Can you help please?

Top Partner = calculate(values('Leads+Exceptions'[PartnerName]),
filter(values('Leads+Exceptions'[PartnerName]),
if(
rankx(
all('Leads+Exceptions'[PartnerName]),count('Leads+Exceptions'[LeadKey]),,DESC)=1,
'Leads+Exceptions'[PartnerName],BLANK()
)

))

I also tried with this formula that I got from thread 'Dax top 1 name' in this forum:

Top ISV = calculate(max('Leads+Exceptions'[PartnerName]),
filter(values('Leads+Exceptions'[PartnerName]),
rankx(
all('Leads+Exceptions'[PartnerName]),count('Leads+Exceptions'[LeadKey]),,desc)<=2),USERELATIONSHIP('Date'[calendar_date],'Leads+Exceptions'[LeadMonth])

)

It gave no errors, but it's not giving the correct result. Perhaps it's not 'grouping' the names together before doing a count, so it's counting each row as 1? My table is akin to the below but obv much bigger!

[LivioLanzo]

@Anonymous

how do you want to return it? in a measure? as a table?

here is a calculated table that will return the top 1

Table =
TOPN (
    1,
    SUMMARIZECOLUMNS (
        'Leads+Exceptions'[PartnerName],
        "Count", COUNTROWS ( 'Leads+Exceptions' )
    ),
    [Count], DESC
)

[Anonymous]

As a measure.

I'd want it to be adaptable so I can change it to find the 2nd as well (in a separate measure).

Thanks