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.
updated measure:
WarehouseQTY =
CALCULATE(
SUM('InvWarehouse'[QtyOnHand]),
'InvWarehouse'[QtyOnHand] > 0
)
Add a slicer visual for Warehouse.
Use this measure in a table or card visual to display the WarehouseQTY.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Thnak you for your reply. With the code you provided ,this is the result that I get for JEMP02
and this is the result for JEMR02
and there is no record of F0061-RAP-A01-L00-T00 in warehouse JEMP09
I thank you in advance for you assistance.