Connecting 3 data tables w/ 2 dimension tables results in "ambiguity"

[michaelho]

I have 3 tables of sales data:

1. Sales Production (new orders created)
2. Sales Profitability (orders that have shipped and are completed)
3. Salesperson Activity (log of salesperson calls/emails)

And 2 dimension tables:

1. dimDate
2. SalespersonID

I am trying to build out a matrix visual that displays the sales data by SalespersonID with a slicer on the dimDate table. However, I can't figure out how to join these 5 tables to allow this to work. If I try to connect the 3 sales data tables (many) to both dimension tables (1), I "introduce ambiguity". Here's a screenshot of what I'm attempting:

And the visualization: