Power pivot relationships not working

Question

I have 4 diffrent tables that I want to mix and match data using pivot table function. Created relationships in data model diagram view, made sure all data types match and to avoid many to many issue i created a lookup table with unique values

However i still get the error message and incorrect results below

What is happeing and how do i get it to work? What is the point of creating relationships if they do not work and i cannot use fields from multiple tables in my pivot?

Attached screenshots in case images do not display

Thanks