Help with DAX formulas

[Syndicate_Admin]

Good day everyone!

I have these two tables and I want to make a measure where I add the output quantity per LOT and multiply it by the unit price of that lot.
Make the formula of the last image, the part of adding the quantities per lot works well, but when I get the unit price per lot, I do not get the expected result.
Could anyone help me?
Best regards!!

[Anonymous]

Hi @Syndicate_Admin 

I think you want to get sum of quantity Per LOT from one Table and then multiply the sum with unit price in another table Per LOT. Due to your screenshot is not clear, I have built an sample for testing by myself. 

Quantity Table:

Unit Price Table:

Measure:

Multiply Per LOT = 
VAR _Quantiy = SUM(Quantity[Quantity])
VAR _Untity = SUMX(FILTER(ALL('Unit Price'),'Unit Price'[Lot] = MAX(Quantity[Lot])),'Unit Price'[Unit Price])
RETURN
 _Quantiy * _Untity

Result:

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.