Calculating gross sales as % of total in different table

[Anonymous]

Hello, 

I have two tables, Orders and Kit Cost Breakdown, that appear below:

Where a the Product Type in the Orders table is "Kit", I need to calculate the gross sales per Kit Comp ID in the Kit Cost Breakdown table. The last column in the Kit Cost Breakdown table is the expected result I am trying to calculate. If the Product Type in the Orders table is "Stock", then there is no further calculation needed for the Gross Sales $. I need to be able to report the Gross Sales $ per Kit Comp ID in the Kit Cost Breakdown Table.

Thanks!

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can create a column

Column = if(RELATED('Order'[Product Type])="Stock",RELATED('Order'[Gross Sales]),RELATED('Order'[Gross Sales])*Kit[Comp% of Cost])

pls see the attachment below