Dax Help

[DustinD]

ive got this dax below and keep getting a resource error. can anyone help me optimize this? trying to only see item numbers in these set locations.  "44WAX", "52WAX", "62WAX", "MAINWAX". any help is appreciated.

[johnt75 · Accepted solution]

Try

SLWohQty =
CALCULATE (
    SUM ( Fact_Inventory[InventoryPhysical] ),
    Fact_Inventory[Warehouse] IN { "44WAX", "52WAX", "62WAX", "MAINWAX" }
)