Subtracting measures not working, help...

[YcnanPowerBI]

Hello all!

I am having an issue I cannot seem to resolve.  I have used the same format for other measures on the same report and they are working fine, but this one is not calculating correctly in all cases - which confuses me even more(see screenshot below).  Here goes...

• My 1st measure: 1 Order Change Volume = SUMX(GROUPBY(Append1,Append1[Ticket ID],Append1[Change in Orders]),Append1[Change in Orders])
  • This measure sums the change in orders at each unique ticket ID
• My 2nd measure: 1 Order v Goal Change = SUMX(GROUPBY(Append1,Append1[Activity Date],Append1[0.5]),Append1[0.5])
  • This measure sums up our .5 model(forecast) at the date level
• Mr 3rd measure: 1 Order Diff = SUMX(Append1,Append1[1 Order Change Volume] - [1 ORDER V GOAL CHANGE])
  • Subtracts my 1st measure from my 2nd

I cant figure our where I am going wrong here and it has now started driving me nuts 🙂  please help

[some_bih]

Hi @YcnanPowerBI 

try v2

1 Order Diff V2 =
[1 Order Change Volume] - [1 ORDER V GOAL CHANGE]