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])
)
)
the formula is summing the whole column [Amount] and not summing by [Item ID] on total stock available
User | Count |
---|---|
16 | |
10 | |
8 | |
5 | |
5 |