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

This measure:

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

Regards