I’m working on an inventory app. In a virtual column, I have this formula: Ref_Rows(“Inventory”, “Item ID”) Which is calculating wrong, although the system shows that the formula has no error. This message appears: “Warning: The argument ‘Item ID’ in...

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]. The total in-stock of all items is gettin...