Forum Discussion
madeline
8 years agoFrequent Visitor
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.
| 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).
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
Community Champion
You could use this measure
File attached as well
Measure = CONCATENATEX ( CALCULATETABLE ( VALUES ( Table1[User] ), FILTER ( Table1, Table1[NumFailedLogins] = MAX ( Table1[NumFailedLogins] ) ) ), Table1[User], ", " )- madelineFrequent Visitor
This is awesome, thanks!