Forum Discussion

lisam12's avatar
lisam12
New Member
4 years ago
Solved

Get value from one column based on expression in another column

Hi all, I have two tables. My Admin Group table is a list of administrators with different values (such as sales, rebates, etc.). I have assigned a score to each administrator in this table based on ...
  • amitchandak's avatar
    amitchandak
    4 years ago

    lisam12 , Try a new column like

     

    measure =
    var _score = CALCULATE(MIN('Admin Groups'[Score]),FILTER('Admin Groups','Admin Groups'[Class ID]=EARLIER('Leaderboard'[Class ID])))
    return
    CALCULATE(MIN('Admin Groups'[Admin FullName]),FILTER('Admin Groups','Admin Groups'[Class ID]=EARLIER('Leaderboard'[Class ID])
    && 'Admin Groups'[Score] = _score))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

lisam12 , Try a new column like

 

measure =
var _score = CALCULATE(MIN('Admin Groups'[Score]),FILTER('Admin Groups','Admin Groups'[Class ID]=EARLIER('Leaderboard'[Class ID])))
return
CALCULATE(MIN('Admin Groups'[Admin FullName]),FILTER('Admin Groups','Admin Groups'[Class ID]=EARLIER('Leaderboard'[Class ID])
&& 'Admin Groups'[Score] = _score))

lisam12's avatar
lisam12
New Member
4 years ago

Worked perfectly! Thank you!