Need help with Measure - get remaining inventory from another table

[RFSOUW]

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]

Thanks

[RFSOUW]

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 · Accepted solution]

@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"
)
)

[bhanu_gautam]

@RFSOUW 

First, ensure that you have a relationship between Table 1 and Table 2 on the Shipment_ID column.

Create a measure in Table 1 to calculate the remaining inventory

DAX
Remaining_Inventory =
CALCULATE(
SUM(Table2[Quantity]),
FILTER(
Table2,
Table2[Shipment_ID] = Table1[Shipment_ID] &&
Table2[Inventory_Status] <> "Sold"
)
)

Add this measure to your Table 1 to see the remaining inventory for each shipment.