Value from measure not displaying correctly in card visual

[hobosapien]

I have the following data set. I am trying to pull the name of the person with the highest adherence. When I place it in a card visual it shows a list of concatenated names. How do I get the measure to produce only one name?

Agent MAX Adherence = 
VAR MaxAdherence =
    TOPN( 1 , 'f_Call Metrics', 'f_Call Metrics'[Adherence %])
RETURN
    CONCATENATEX(MaxAdherence, 'f_Call Metrics'[Agent])

Agent	Date	Adherence %
Jocelyn Vazquez	1/18/2024	0.976
Jocelyn Vazquez	1/24/2024	0.94
Jocelyn Vazquez	1/25/2024	0.972
Jocelyn Vazquez	1/30/2024	0.972
Jocelyn Vazquez	1/31/2024	0.989
Isaias Wiggins	3/18/2024	0.957
Isaias Wiggins	3/25/2024	0.96
Isaias Wiggins	4/3/2024	0.976
Isaias Wiggins	4/19/2024	0.885
Isaias Wiggins	5/3/2024	0.917
Donovan Christian	5/8/2024	0.926
Donovan Christian	5/23/2024	0.891
Donovan Christian	5/31/2024	0.928
Donovan Christian	8/2/2024	0.843
Donovan Christian	8/22/2024	0.903
Rafael Beck	8/19/2024	0.964
Rafael Beck	10/31/2024	1
Shiloh Anderson	1/2/2024	0.963
Shiloh Anderson	1/9/2024	0.965
Shiloh Anderson	1/11/2024	0.944
Shiloh Anderson	1/12/2024	0.973
Shiloh Anderson	1/17/2024	0.966

[Anonymous]

Hi @hobosapien ,

Thank you for your interest in this case.

Using your syntax works fine for me and I cannot reproduce your error. I think the error may be in the fact that the CONCATENATEX function concatenates more than one name instead of extracting just one.

CONCATENATEX function (DAX) - DAX | Microsoft Learn

Try another syntax, this works fine.

Agent_MAX_Adherence = 
VAR MaxAdherence =
    MAXX('f_Call Metrics', 'f_Call Metrics'[Adherence %])
VAR TopAgent =
    FILTER(
        'f_Call Metrics',
        'f_Call Metrics'[Adherence %] = MaxAdherence
    )
RETURN
    MAXX(TopAgent, 'f_Call Metrics'[Agent])

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[ThxAlot]

1. Hover the mouse over the funnel icon to see what underlying filters are,
   
2. Your measure might work correctly in most cases, but can't handel a dataset with duplicated max metrics,
   AgentDateAdherence %

   Jocelyn Vazquez	1/31/2024	0.989
   Isaias Wiggins	3/18/2024	0.957
   Isaias Wiggins	3/25/2024	0.96
   Isaias Wiggins	4/3/2024	0.976
   Isaias Wiggins	4/19/2024	0.885
   Donovan Christian	8/2/2024	0.843
   Donovan Christian	8/22/2024	0.903
   Rafael Beck	8/19/2024	0.964
   Rafael Beck	10/31/2024	1
   Rafael Beck	10/31/2024	1
   Shiloh Anderson	1/2/2024	0.963
   Shiloh Anderson	1/9/2024	0.965

   

[hobosapien]

For some reason neither of these options worked - the name being returned didn't match the highest average adherence %. I do have a team slicer that is based off a "team" column of this table so that I can filter by team and show the top name for each team. I didn't think that would affect the way the measure was working as it's returning the name of the agent.

[shafiz_p]

Hi @hobosapien  Try this:

Agent MAX Adherence = 
VAR MaxAdherence =
    MAXX(TOPN(1, 'f_Call Metrics', 'f_Call Metrics'[Adherence %]), 'f_Call Metrics'[Agent])
RETURN
    MaxAdherence

or 

Agent MAX Adherence = 
VAR MaxAdherence =
    TOPN(1, 'f_Call Metrics', 'f_Call Metrics'[Adherence %])
RETURN
    SELECTEDVALUE(MaxAdherence[Agent])

or

Agent MAX Adherence = 
VAR MaxAdherence =
    TOPN(1, 'f_Call Metrics', 'f_Call Metrics'[Adherence %])
RETURN
    FIRSTNONBLANK(MaxAdherence[Agent],MAX(MaxAdherence[Adherence %]))

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[Irwan]

hello @hobosapien 

i got only one name with your DAX (Rafael Beck as the highest value)

Thank you.