general measure in a table

[YarinInbar]

Hey, 

I have a table that shows item sales by store. 

I want to add a column that showing the inventory of the sold item for all stores and not only for the specific store that the row is related with. how do i do that?

this is the measure right now:
NUM(
$(vInventoryLastKnownBalance)
,'#,##0')

It's showing a result only for the store the row is related with.

[abhijitnalekar]

Hello @YarinInbar ,

Use Total in your set expression. eg

sum( Total sold)

Or show the expression behind the variable.

I have been assuming that you are looking something like below.

=sum({1} Total Sales) this will work for you.

[YarinInbar]

I tried =sum({1} Total [Inventory QTY]) and the result I get is not correct 😣

[abhijitnalekar]

Can you please share your chart or table structure.

[YarinInbar]

It's something like that:

STORE	ITEM UPC	SALES QTY	CUREENT ITEM INVENTORY IN THIS STORE	CURRENT ITEM INVENTORY IN ALL STORES
STORE 1	12345	1	0	16
STORE 2	12345	1	5	16
STORE 3	12345	1	1	16
STORE 4	12345	1	2	16

I want the last column to show the current inventory in all of the stores, even if they are not shown on the table (because they didn't sell the item in current date selection).

I have a field that bringing the current inventory for the item, I just want to know how to "disconnect" it from the stores on the table and "connect" it to the upc - so It'll tell the inventory by upc and not by store.

[abhijitnalekar]

Hi @YarinInbar ,

With the above requirement, I will suggest that create a summarise UPC table like

ITEM UPC, sum or Count inventory

and you can join the table to the main table with ITEM UPC field.

[YarinInbar]

Thank you, can you explain how do I join the table?

[abhijitnalekar]

Hi @YarinInbar ,

Can you please share sample data, so that I can explain you on the same dataset.