Show sum of a group on tabel base

[Anonymous]

Hi I hope I can explain well what I am trying to achieve.
I have 3 tables which I am trying to link together.

In the Salesline I have many lines with the same Item and sold Quantity.

In The Warehouse i also have many lines with the Same Item and the stored Quantity. 

(Red colums are not availabel in the datasource at the Moment.)

I would need the sum of theses two Quantitys and subtract them from Each other. 

I want to show the individual saleslines from my sales filterd by Item.
At the end of the tables I want to see how many parts are left in my stock.
So in my target table for the same ItemID in each line should be the same value.

I tried it with verious measures or adding the grouped Sum in the datasource but could not find a way to make it work.

I hope its understandable. 

Thank you for your help!

[tamerj1 · Accepted solution]

Hi @Anonymous 
I guess the number should be 50 i.e. (10 + 40) not 30

Please try the following measures

Quantity Sum =
CALCULATE (
    SUM ( Salesline[Quantity] ),
    REMOVEFILTERS (),
    VALUES ( Sales[Item] )
)

Warehouse Sum =
CALCULATE (
    SUM ( Warehouse[Warehouse] ),
    REMOVEFILTERS (),
    VALUES ( Sales[Item] )
)

[Anonymous]

Hi @tamerj1, 

yes of cause i meant that.

Thank you very much that was the perfect soulution!!