https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Help/m-p/3327760#M124639 <P>Try</P> <LI-CODE lang="markup">SLWohQty = CALCULATE ( SUM ( Fact_Inventory[InventoryPhysical] ), Fact_Inventory[Warehouse] IN { "44WAX", "52WAX", "62WAX", "MAINWAX" } ) </LI-CODE> Wed, 12 Jul 2023 15:29:54 GMT johnt75 2023-07-12T15:29:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Help/m-p/3327656#M124631 <P>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.&nbsp;&nbsp;<SPAN>"44WAX"</SPAN><SPAN>, </SPAN><SPAN>"52WAX"</SPAN><SPAN>, </SPAN><SPAN>"62WAX"</SPAN><SPAN>, </SPAN><SPAN>"MAINWAX". any help is appreciated.</SPAN></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 12 Jul 2023 14:49:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Help/m-p/3327656#M124631 DustinD 2023-07-12T14:49:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Help/m-p/3327760#M124639 <P>Try</P> <LI-CODE lang="markup">SLWohQty = CALCULATE ( SUM ( Fact_Inventory[InventoryPhysical] ), Fact_Inventory[Warehouse] IN { "44WAX", "52WAX", "62WAX", "MAINWAX" } ) </LI-CODE> Wed, 12 Jul 2023 15:29:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Help/m-p/3327760#M124639 johnt75 2023-07-12T15:29:54Z