LookUpValue with Filter

[Anonymous]

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

[Jos_Woolley]

That must mean that your table can contain duplicate entries. Post some more realistic data, since that which you posted does not contain any duplicates.

Regards

[Anonymous]

Thanks! I fixed up my data and removed the duplicates and it works! Thanks so much

[Anonymous]

Hi @Jos_Woolley  - I get this error: 

[Jos_Woolley · Accepted solution]

This measure:

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

Regards