SUM qty field, but decrement from sum when new variable added?
Need guidance! I'm looking to sum a quantity column, but filter by 2 separate visuals. The difficulty I am having is decrementing the quantity when an added variable is introduced.
I'm looking for the quantity sum in WIP using the ASLY & TEST fields as my current filters. Below I can easily filter to get what quantity is in ASLY (qty 2 based on below), but when I add in a test date, the ASLY quantity doesn't decrement.
I am unsure how to include a statement to decrement? Thoughts?
No slicers. Here's a more complete picture. As you can see, I'm trying to see where the units remaining to ship are in the process. The DAX measure you provided does show the correct quantity in my WIP Assembly card, but when a TEST date is added to move the product to WIP Test, the WIP Assembly card does not decrement.