We have an issue where we have two identical data sources to compare year over year numbers from different years (i.e. 2017 to 2014, 2017 to 2015, 2016 to 2014, 2016 to 2013).

We've blended these two identical data sources using three dimensions. When we add a fourth dimension, the measure totals for the year change slightly.

For example, when I select 2016 to 2014 there's a slight difference in the totals for 2016 than when I select 2018 to 2016 (or 2017 to 2016/2016 to 2015). When I select 2016 to 2016, I get the correct total. When I select the other options between years the 2016 total changes. With the other three dimensions, the measures total correctly. All dimensions aside from the year selection are not data/time.

Can anyone give me a solution to this problem or has anyone else experienced this issue?