Return a value from a column based on a MAX value in another

[hobosapien]

I have the following table and I am trying to return the name of the person from the Agent column with the max value of AVG Adherence.

I attempted to use TOPN but it returns the name and the value, whereas I only need the name to display it in a card.

VAR MaxAdherence =
    TOPN( 1 , 'ct_Call Metrics', 'ct_Call Metrics'[AVG Adherence])
RETURN
    MaxAdherence

Agent	AVG Adherence
Aubriella Maddox	88.48%
Connor Oliver	86.99%
Luke Rosales	84.82%
Jocelyn Vazquez	93.24%
Esme Mullen	88.35%
Sara Evans	91.47%
Elias Marshall	87.11%
Donovan Christian	87.05%
Rafael Beck	89.64%
Shiloh Anderson	90.69%
Kehlani Flynn	86.41%
Isaias Wiggins	91.81%

[ThxAlot · Accepted solution]

[hobosapien]

This worked, thank you!

[Irwan]

hello @hobosapien 

please check if this accomodate your need.

create a new measure with following DAX

MaxAdherence = 
var _Max = MAX('Table'[AVG Adherence])
Return
MAXX(
    FILTER(
        'Table',
        'Table'[AVG Adherence]=_Max
    ),
    'Table'[Agent]
)

Hope this will help.

Thank you.