Maths equation on columns from multiple tables

Hello,

I wrote a long question before and it seems to have disappeared...

I am trying to perform the following equation:

( Table1[Revenue] / Table2[WDIC] ) * Table2[CWDSF] / Table3[Hours]

Table1 contains CustomerId and Revenue (whole number)

Table2 is a summarisation of a Calendar table with some extra calculated columns

Table3 contains CustomerId, DoneDate, and Hours (whole number)

Table4 is a Customers table with CustomerId and CustomerName

Table1 has a 1:1 Relationship with Table4

Calendar has a *:1 Relationship with Table2 (based on a column with "MMMM_YYYY")

Table3 has a *:1 Relationship with Table4 (based on CustomerId)

Table3 has a *:1 Relationship with Calendar (based on Table3[DoneDate] = Calendar[Date]) 

Would someone please be able to help me create the following output in a table visualisation? The result column:

This table has a filter so that it will always show the current month (i.e. September 2022)

The closest I got returned 100s of rows with each of the CustomerId duplicated multiple times and the result column was duplicated too.