Forum Discussion

CoreyP's avatar
CoreyP
Solution Sage
6 years ago

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...
Need Help
kentyler's avatar
kentyler
Solution Sage
6 years ago

and you can short cut the filter statement 

FILTER (
ALL('Inventory'[Pallet Rank]),
'AIRMInventory'[Pallet Rank] <= cur_index ))
by just writing
, 'AIRMInventory'[Pallet Rank] <= cur_index
as an argument to CALCULATE
CALCULATE will turn it into a filter automatically
  • kentyler's avatar
    kentyler
    Solution Sage
    6 years ago

    I know the feeling. It can't seem impossible. There is just some little detail we have to find.

    If you just write the Rankx measure (following his example) in a measure and put it in a table, what does it return ?