Forum Discussion
Syndicate_Admin
Administrator
5 years agoHelp with DAX formulas
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, ...
Anonymous
5 years agoNot applicable
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.