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
SUM(
SELECT(
Inventory[Amount],
([Item ID] = [_THISROW].[ID])
)
)


