Engagement Role Report - Calculated Column question

[jdormer]

I am having some difficulty creating a measure to display the individuals working on an engagement and their roles. I have the following tables:

 

The managers table lists Managers for each engagement. The AllocationID indicates the individuals role on the team: Salesperson (1), Project Manager (2), or Architect (3). 

 

I'd like to create a report that displays the Salesperson, Project Manager, and Architect for each engagement, as seen below. To do so, I'm trying to create a Salesperson column (or measure?), PM column, and architect column. I've looked at the functions CALCULATE, FILTER, RELATED, and others but I'm having difficulty determining the correct formula to populate these columns with the correct information. 

Let me know if any additional information would be helpful. 

Thanks.