Forum Discussion

nagaraj's avatar
nagaraj
Post Patron
6 years ago
Solved

LookupValue with Filter

Hi,    Need help with DAX for below scenario   Scenario: Have TABLE1 and TABLE2, need to populate manager (in TABLE1) by having lookup (in TABLE2). In TABLE2 i have multiple values for a single ...
Need Help
  • nagaraj's avatar
    nagaraj
    6 years ago

    Hi tctrout 

     

    Thanks for the help, was able to resolve using below 

     

    Property_Manager = CALCULATE(FIRSTNONBLANK(Table2[Name],1),
    filter(all(Table2),
    Table2[Type] ="Property Manager" &&
    'Table1'[Id] = Table2[Id]))

MG86's avatar
MG86
Advocate II
5 years ago

I know this is an older thread, but for future reference isn't it easier to just use the second lookup parameters of LOOKUPVALUE?:

LOOKUPVALUE(
   'Table2'[Name], 'Table2'[Id], 'Table1'[Id], 'Table2[Type], "Manager")

BerryBIA's avatar
BerryBIA
Advocate I
3 years ago

this is the only correct answer !