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