Running calculation bug

[goyalsa]

Hi all,

I am struggling to figure this out. Would really appreciate your help.

Scenario:

In the Stock overview matrix, I have total supply and total demand. The Gross Inventory = Total Supply - Total Demand and then the gross inventory for 202211 will be starting stock for 202212.

Gross Inventory Measure = 

Gross Inventory = CALCULATE([Total Supply]-[Total Demand], FILTER(ALLSELECTED(Dates),Dates[Loadingweek] <= MAX(Dates[Loadingweek])))

But the problem is sometimes I get the total demand -ve and at that time I do not want to include that total demand in the calculation. Then I want to take Forecasted demand from the Demand Matrix. 

Thank you in advance!!

[amitchandak]

@goyalsa ,

Gross Inventory Measure =
Gross Inventory = CALCULATE([Total Supply]-if([Total Demand]>0,[Total Demand],0) , FILTER(ALLSELECTED(Dates),Dates[Loadingweek] <= MAX(Dates[Loadingweek])))

[goyalsa]

Hi @amitchandak ,

There is still no difference in the result.