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]))

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi nagaraj ,

 

We can try to create a calculated column in 'Table 1' to meet your requirement:

Manager =
CALCULATE (
    MAX ( 'Table 2'[name] ),
    'Table 2'[Type] = "Manager",
    'Table 2'[id] = 'Table 1'[id]
)

 


Best regards,

 

 

  • nagaraj's avatar
    nagaraj
    Post Patron
    6 years ago

    v-lid-msft 

     

     HI, 

     

     Thanks for the help, was able to resolve this using the below 

     

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