Calculating total sum in relation to unit cost from master table

[Anonymous]

Hi, 

How can I calculate total cost based on two tables below?

Table 1 (left one) does not have quantity, each row counts as 1 unit. 

Referencing Table 2 listing unit cost against product, I would like to calculate total cost in Table 1. 

If there was Qty column in Table 1, I would have used below

calculate(sumx('Table1',Table1[Qty]*lookupvalue(Table2[Unit cost],Table2[Product],Table1[Product])))

However, without quantity, I am not sure how to calculate. 

[Al_Bundy]

Do you have relationships created between the two tables?  Could merge the two tables...

[Fowmy · Accepted solution]

@Anonymous 
Not clear but I assume your default QTY is one.

CALCULATE (
    SUMX (
        'Table1',
        1
            * LOOKUPVALUE ( Table2[Unit cost], Table2[Product], Table1[Product] )
    )
)