Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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?
Need Help
Show and Tell
Tips and Tricks

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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