How to return a value from another column based on multiple criteria

[Anonymous]

I'm looking to grab the column called "Recruiter" from the 'Recruiting History' table into the 'Applications Report' table for the below filters.

FILTER(

'Recruiting History',

'Recruiting History'[History Submittal ID] = 'Applications Report'[SubmittalID] &&

('Recruiting History'[Status] = "Phone Screen Completed" ||

'Recruiting History'[Status] = "Phone Screen Scheduled")

)
How do I do this in DAX?

[Anonymous]

Hi @Anonymous ,

Based on your description, I suggest you can try the "LOOKUPVALUE()" function.

Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.

You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

Best Regards,

Yuna

[lbendlin]

You can't do that. Filters are applied to the context, not to a physical table.

Put your columns from the Applications report into visuals or table variables (thus creating context) and then apply the filters.

Show your data model.