Can Get total in Matrix to be used in lines

[SebSchoon1]

Hello,

after so many hours i'm still not able to manage something.

I have a matrix Table like this 

I have first a category of items

With dimension (DIM)

Without Dimension (UNI)

I would like to have Quantity = 4 in Warehouse 013 Since i have one size on each item reference

I have created a Summarized table which shows me exactly what i'm looking for. 

However, i Absolutely don't no i'n my model how to join that table. since I do not have any unique Key

Does anybody have any advice? 

Maybe i could use a measure?

Many thanks for your help!

[PowerUserR]

Hi, have you tried connecting the desired table to the table above it? From a first glance it looks like they have a column in common.

I assume that you've tried this already? 

If this doesn't help, I think having some sample data or the pbix file could help.

[SebSchoon1 · Accepted solution]

Hi, @PowerUserR 

Yep, i have to use that data

I Think i found a non conventional solution which consist in creating a new column with

[ITEM CODE]&[WarahouseID]   in my stock table.

Then Summarize data with addcolumn(summarize(....

and link that virtual table to stock table.