topic Re: Show sum of a group on tabel base in DAX Commands and Tips

Show sum of a group on tabel base

Anonymous — Mon, 24 Oct 2022 15:57:19 GMT

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!

Re: Show sum of a group on tabel base

tamerj1 — Mon, 24 Oct 2022 16:34:42 GMT

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] ) )

Re: Show sum of a group on tabel base

Anonymous — Mon, 24 Oct 2022 19:58:00 GMT

Hi tamerj1,

yes of cause i meant that.

Thank you very much that was the perfect soulution!!