how to get the maximum number of calls answered persons name

[cham]

Hi,

I want show a Card in Power BI showing maximum number of calls answered user and number of calls he answered.

Ex- I want to show B and number of calls he answered = 45

[Zubair_Muhammad · Accepted solution]

@cham

Try this measure

Measure =
VAR MyName =
    CONCATENATEX ( TOPN ( 1, Table1, [Answered], DESC ), [Name], ", " )
RETURN
    "Maximum number of calls answered were " & MAX ( Table1[Answered] )
        & " which were answered by user "
        & MyName

[cham]

Thank You so much