CURRENT STOCK

I’m working on an inventory app. I am using the formula below:
Sum(Select(Inventory[Amount], [ITEM ID]=[_THISROW].[Item ID]))
But the formula is summing the whole column [Amount] and not summing by [ID Item] on total stock available

Admin11a1ab_0-1693593135081.png

 

0 2 106
2 REPLIES 2

SUM(
  SELECT(
    Inventory[Amount],
      ([Item ID] = [_THISROW].[ID])
  )
)

the formula is summing the whole column [Amount] and not summing by [Item ID] on total stock available

 

Admin11a1ab_0-1693845633133.pngAdmin11a1ab_1-1693845675742.png

 

Top Labels in this Space