You have a number of different problems here. First of all, you're trying to show the change between the two years that you've filtered, but then using an LOD. If you look at Tableau's Order of Operations, you'll see that dimension filters are calculated after FIXED LOD calculations, so your LOD is actually getting the MAX and MIN years in the entire data set, not the years you've selected. To correct that, you should add that filter to context. Context filters are calculated before FIXED LOD calculations. In the same light, you should also add your region filter to context.

A second problem is that a lot of the countries' 2016 data has zeros so you can't really calculate a change from year to year because you'll get a divide by zero problem. To avoid that issue, I'm looking at 2015 vs 2017.

To simplify some of the calculations, I've broken out your Calculation1 into 3 separate calcs:

Fav - First Year

// SUM of Fav for the first selected year.

{ FIXED [Country]:SUM(IF [Year]= {FIXED [Country]:MIN([Year])} THEN

[Fav] END)

}

Fav - Last Year

// SUM of Fav for the last selected year.

{ FIXED [Country]:SUM(IF [Year]= {FIXED [Country]:MAX([Year])} THEN

[Fav] END)

}

Change

// Change from first year to last year.

([Fav - Last Year]-[Fav - First Year])/[Fav - First Year]

Finally, we'll do one more calculation to find which country has the min and max change:

Change Category

// Identify the countries with the min/max amount of change.

IF [Change]={FIXED : MAX([Change])} THEN

"Max"

ELSEIF [Change]={FIXED : MIN([Change])} THEN

"Min"

ELSE

"Other"

END

Drag Change Category to the color card, then change the colors as desired.