Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

LookUpValue with Filter

Hi all,

I'm trying to do a lookupvalue with a filter but can't seem to get it working.

I want to create a Measure to Lookup the "Group Role" where the "People Leader" is TRUE and return the "Name".

This should give me a new column with the following data:

ROW 1 Krystle Te Raki

ROW 2 Jason Gould

ROW 3 Krystle Te Raki

ROW 4 Henry Wong

ROW 5 Jason Gould

ROW 6 Krystle Te Raki

ROW 7 Henry Wong

This measure:

Measure =
LOOKUPVALUE(
    'Table'[Name],
    'Table'[Group Role], MIN( 'Table'[Group Role] ),
    'Table'[People Leader], TRUE
)

Regards

Solution Sage

This measure:

Measure =
LOOKUPVALUE(
    'Table'[Name],
    'Table'[Group Role], MIN( 'Table'[Group Role] ),
    'Table'[People Leader], TRUE
)

Regards