Get a column's value(s) based on another column's max

[madeline]

In my table, I have a calculated column (NumFailedLogins) which shows the number of times a user appears based off of a condition. Now, I want to get a value from another column (User) based off of the max from the calculated column (NumFailedLogins). There is a possibility of multiple users having the same max value, but I only need to return at least one of them.

User	NumFailedLogins
Mary	3
Mary	3
Mary	3
Frank	2
Jane	0
Frank	2
Frank	2
John	3
John	3
John	3
Frank	2

In the above example, I would like to return either Mary or John (or both if that's even possible. If not, it's fine). 

[Zubair_Muhammad · Accepted solution]

@madeline

You could use this measure

File attached as well

Measure =
CONCATENATEX (
    CALCULATETABLE (
        VALUES ( Table1[User] ),
        FILTER ( Table1, Table1[NumFailedLogins] = MAX ( Table1[NumFailedLogins] ) )
    ),
    Table1[User],
    ", "
)

[madeline]

This is awesome, thanks!