topic Re: Value from measure not displaying correctly in card visual in DAX Commands and Tips

Value from measure not displaying correctly in card visual

hobosapien — Sun, 19 Jan 2025 20:29:33 GMT

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

Re: Value from measure not displaying correctly in card visual

Irwan — Sun, 19 Jan 2025 23:45:47 GMT

hello hobosapien

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

Thank you.

Re: Value from measure not displaying correctly in card visual

shafiz_p — Mon, 20 Jan 2025 04:22:54 GMT

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

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

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

Re: Value from measure not displaying correctly in card visual

ThxAlot — Mon, 20 Jan 2025 08:51:27 GMT

Hover the mouse over the funnel icon to see what underlying filters are,

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

Re: Value from measure not displaying correctly in card visual

hobosapien — Tue, 21 Jan 2025 03:15:38 GMT

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.

Re: Value from measure not displaying correctly in card visual

Anonymous — Tue, 21 Jan 2025 06:13:13 GMT

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!