STOCK BY ITEM ID

HELLO, IM WORKING ON AN INVENTORY APP, I AM NEW ABOUT USING FORMULAS

WHAT I WANT IS A FORMULA THAT GETS THE STOCK OF EVERY ITEM

FOR EXAMPLE

ITEM 01 HAS 5 PRODUCTS

ITEM 02 HAS 3 PRODUCTS

WHAT I WANT IS THAT THE QUANTITY OF PRODUCTS APPEARS, I TRIED USING TOTAL STOCK AVAILABLE BUT THAT FORMULA SUMS ALL THE AMOUNT PRODUCTS AND NOT BY ITEM ID

It gives total amount Because you are adding (sum) Amount. You expression is wrong.

BTW where is the column [Quantity] in the table?

Sum (

Select ( inventory [Quantity] …

sorry is not quantity, is the column amount

So i need to create a column Quantity in the table

and use this expression? SUM(
SELECT(Inventory[Quantity], ([Item ID] = [_THISROW].[Item ID]))
)

1 Like

Yes absolutely…