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 t...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

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

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

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's avatar
    madeline
    Frequent Visitor
    8 years ago

    This is awesome, thanks!