Forum Discussion

madeline's avatar
madeline
Frequent Visitor
8 years ago
Solved

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

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.

UserNumFailedLogins
Mary3
Mary3
Mary3
Frank2
Jane0
Frank2
Frank2
John3
John3
John3
Frank2

 

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). 

  • 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],
        ", "
    )

     

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion

    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],
        ", "
    )