Forum Discussion
Solved
Warehouse Qty
Good Day All. I need help with the following please. I thank you in advance for your help and assistance. I have ave build I slicer that list the warehouses. What I want to achieve is that wh...
PBI file attached.
Hope this helps.
try this:
WarehouseQTY =
SUMX(
FILTER(
'InvWarehouse',
'InvWarehouse'[QtyOnHand] > 0
),
'InvWarehouse'[QtyOnHand]
)
This adds all the values together and show 1009 pcs in warehouse JEMP09 and 1009 pcs in warehouse JEMR02. and 0 pcs in warehouse JEMP09
