Dax question regarding filtering prior dates and getting correct totals.

[rcassel]

I'm trying to filter out 2016 where amount is =2 and am not getting the Grand Totals for FilteredDifferences working correctly. 

FilteredDifferences =
var vmax = CALCULATE (SUM ( 'Table'[AMOUNT] ),FILTER ( 'Table', 'Table'[YEAR] = MAX ( 'Table'[YEAR] ) ))

var vmin = CALCULATE (SUM ( 'Table'[AMOUNT] ),FILTER ( 'Table', 'Table'[YEAR] = MIN ( 'Table'[YEAR] ) ))
return
IF (
            HASONEVALUE ( 'Table'[YEAR] ),blank(),
         if(vmax=2, BLANK(), vmax - vmin)
)

 How can I get the correct totals to work? Thanks. 

[Greg_Deckler · Accepted solution]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[rcassel]

Thanks Greg, it worked.  I had to create a measure then use Summarize for Totals. 

FilteredDifferences = 
var vmax = CALCULATE (   SUM ( 'Table'[AMOUNT] ),
                        FILTER ( 'Table', 'Table'[YEAR] = MAX ( 'Table'[YEAR] ) )     )

var vmin =     CALCULATE (SUM ( 'Table'[AMOUNT] ),
                            FILTER ( 'Table', 'Table'[YEAR] = MIN ( 'Table'[YEAR] ) )        )
      
var vdiff = if(vmax=2, BLANK(),vmax-vmin)/2

var vzoneyear = SUMMARIZE('Table','Table'[ZONE], 'Table'[YEAR]) 
var vtotal = sumx(vzoneyear, CALCULATE(vdiff))

VAR __table = SUMMARIZE('Table',[ZONE],"__value", [RowDifference]) 

return

IF(HASONEVALUE('Table'[ZONE] ),vtotal,SUMX(__table,[__value]))