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"
)
)
Hi Bhanu,
Thanks. It works...if I can ask once more..if I have two statused I need to filter out (Sold & Reserved), can I simply add &&
Remaining_Inventory =
CALCULATE(
SUM(Table2[Quantity]),
FILTER(
Table2,
Table2[Shipment_ID] = Table1[Shipment_ID] &&
Table2[Inventory_Status] <> "Sold" && Table 2[Inventory_Status]<>"Reserved"
)
)
Thank you!
bhanu_gautam
Super User
Super UserRFSOUW 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"
)
)