Need help with Measure - get remaining inventory from another table

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.

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!

Thanks