Help

I created a Project dimension table and added 1:m relationships to the 3 main tables.

I made the existing relationships between fact tables inactive ( I would probably delete them but I left that for you to do if required).

I've changed the measure on the first table to be a little simpler but you'll need to check the impact on the rest of the report.

I would advise creating your own Dates table and using that instead of the built-in date features (entirely up to you).

It also looks like the CoW productivity table is really a slowly changing dimension so you might want to do something with this (I didn't investigate too much because I wanted to do the simplest thing that works to fix the initial posted question).

I'll send the pbix thru the internal mail system.

Let me know how it goes.