Need to multiply a column from each fact table together to get a new column

[Anonymous]

I have a Sales Table and a Shipments Table... I need to multiple Cost from Shipments Table by Units Sold in Sales Table

These are connected by a date table, a customer attributes table, and a Product table.

I have tried to just create a measure, but the results aren't accurate

I have tried to bring "related" into the Shipments table to pull in that column form Sales Table, but since they aren't directly related (connected through Customer Attributes, Dates and Product Tables) it won't work.

Anyone have any solutions please? I'm losing it haha

[davehus · Accepted solution]

Hi @Anonymous ,

Are you able to bring the cost into the product in some way using related and the use a sumx that way. 

Another way could be to summarize the table but it might not be the approach you want.

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.