I have a table with each line showing item id , location id, quantity on hand.
My table has multiple locations but I'm interested in checking if 2 specific locations have or not have an item in stock. If location 1 doesn't have the item and location 2 has I want to flag it as "replenish". When I use the formula below as a calculated column it's classifying everything as "Has Stock".
I'm not sure if the problem is in my dax or somewhere else...can someone please check if the dax below makes sense?