Forum Discussion
A seemingly complex task...
Hey all, I've got what might be a fun one for all you experts. Here's what I'm trying to do: If any of you have a background in warehouse management, you might get this right off the bat. I'm...
I think you want to store the current value before you do calculate
Cumulative Qty =
var cur_index = max('inventory'[Pallet rank])
CALCULATE (
SUM( 'Inventory'[ONHAND_QTY] ),
FILTER (
ALL ( 'Inventory'[Pallet Rank] ),
'Inventory'[Pallet Rank] <= cur_index )
)
)
That doesn't seem to be working. Just returns 1 for every value. Do we have to take item_no into context somehow?