Incorrect Measure Total - subtracting between two Month over Month measures

Question

Hello,&nbsp;I'm trying to get my Total Changes&nbsp;measure&nbsp;to calculate correctly. I'm using a matrix visual.&nbsp;Red is what I get currently, Green is the desired total.YearMonthThis MonthLast MonthMonthly Variance2019Jan19,223,32118,290,500932,8212019Feb19,651,17319,223,321427,8522019Mar19,891,79619,651,173240,623&nbsp;&nbsp;&nbsp;Current Total40,475,790&nbsp;&nbsp;&nbsp;Desired Total1,601,296&nbsp;&nbsp;Measures:This Month = SUM(Table[Widgets])Last Month = CALCULATE([This Month], PREVIOUSMONTH(DimDate[Date]))Monthly Variance = [This Month] - [Last Month]Final Measure&nbsp;= IF(HASONEVALUE(DimDate[Year]) &amp;&amp; HASONEVALUE(DimDate[Month])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,[Monthly Variance]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,?? // this line is what I'm trying to solve&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)&nbsp;I've been scouring the forums all day and can't seem to get this to work. I've tried variations using SUMX and SUMMARIZE but have yet to be successful.&nbsp;Any assistance is very much appreciated! Thank you!&nbsp;Grant

parry2k · Accepted Answer

hyggins try to change your measure like below and then it should work and total of your monthly variance will be correct.
&nbsp;
Last Month = 
CALCULATE(
[This Month],
DATEADD( DimDate[Date], -1, MONTH )
)

Forum Discussion

Incorrect Measure Total - subtracting between two Month over Month measures

2 Replies

Related content

Measure returning incorrect value

Measure Total Incorrect

Subtraction calulation

DAX Measure Returning Incorrect Results

DAX Subtracting two measures

Year	Month	This Month	Last Month	Monthly Variance
2019	Jan	19,223,321	18,290,500	932,821
2019	Feb	19,651,173	19,223,321	427,852
2019	Mar	19,891,796	19,651,173	240,623
			Current Total	40,475,790
			Desired Total	1,601,296