DAX expression for below query

I have 5 tables. Below the attached screenshot with tables and fields.     I need to display the reports details based on the User project id and partner id. Users have two roles 'Project R...