Ambigious Relationship when trying to filter

You want to aim at changing the table structure to being a star schema.

You need a central fact table with dimensions coming off it. The key thing is in an analytics database the only thing that needs to be filtered is the central fact table.

Part of the approach to getting there would be to flatten some of your dimensions eg system and subsystem probably want to become a single table. Then in the fact table you need a ProjectId, SystemId, DisciploneId etc.

You can do all that transform inside

of power query.

You'll find it all works and your dax is much easier to write.