topic Return a value from a column based on a MAX value in another in DAX Commands and Tips

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

hobosapien — Sun, 12 Jan 2025 21:43:50 GMT

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%

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

Irwan — Sun, 12 Jan 2025 23:10:31 GMT

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.

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

ThxAlot — Mon, 13 Jan 2025 08:46:32 GMT

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

hobosapien — Tue, 14 Jan 2025 02:41:06 GMT

This worked, thank you!