Forum Discussion
Solved
Need help with Measure - get remaining inventory from another table
Guys, Kindly help with the measure to get the total remaining quantity by Inventory status per shipment from another table. Below is my scenario Greatly appreciate your inputs
RFSOUW Yes you can
Remaining_Inventory =
CALCULATE(
SUM(Table2[Quantity]),
FILTER(
Table2,
Table2[Shipment_ID] = Table1[Shipment_ID] &&
Table2[Inventory_Status] <> "Sold" &&
Table2[Inventory_Status] <> "Reserved"
)
)
Thanks