Can't calculate stock on hand

[SebSchoon1]

Hi guys, 

Many thanks for the great power bi community!

It is my first post I Searched a long time before sending this request.

I have a fact table. 

Which contains each movement types, dates, quantities, etc etc.

I created many measure filtering positive stock movements ( selected by calculate(sumx(quantity, movementtype = "supplier invoice"). Etc with changing the filter name in the filter part of the calculate for each positive movement type needed.

Like this calculate(sumx(quantity, movementtype = "xxxxx")

Same way for negative movements.

Then a formula.

Positive movement = a+b+c ="all positive measures" 

Same for negative movements.

I would like to calculate the stock on hand by warehouse. And only show items on hand.

But agreggated values are not correct. 

Moves are calculated from 2010 up to today.

I can provide more information if needed thanks guys!!

[Whitewater100]

Hi:

Can you share your file or example data, with example of correct result?  Thank you..

[SebSchoon1]

Hi,

Many thanks for your Answer,

relations

And when i check my stock level at item level it is ok i cand find each item.

However totals are wrong, in my 015 warehouse i should be around 41K items.

I think that the total is not calculated on todays available stock but on the whole Set of Data.

I also Have a Slicer which can probably impact the resulT.

[SebSchoon1]

I have not been really accurate.

I have finally created a formula doing

Positive movement (+) +negative movements (-) 

And that formula does not seems to give me the right information.

I also use a slicer with a calendar table.

To get an image of stock on demand.

However I can only use right side of that slicer, because if I use the left one some items can not to be taken into account. 

Ex if I want the average stock on one year I cannot do it