Forum Discussion

Anonymous's avatar
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 "...
DAX
measure
  • Jos_Woolley's avatar
    Jos_Woolley
    3 years ago

    This measure:

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

    Regards

Jos_Woolley's avatar
Jos_Woolley
Solution Sage
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

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