Average Function Affected by Hierarchy
I have a module which calculates an average using this formula:
'DATA01'.'Hours'[AVERAGE: 'DATA01'.Job Code, AVERAGE: 'DATA01'.Date]
I want to add a regional context selector to this module so that I can view the average separately for each region. I added Region as a dimension in this module and updated the formula to include the region:
'DATA01'.'Hours'[AVERAGE: 'DATA01'.Job Code, AVERAGE: 'DATA01'.Region, AVERAGE: 'DATA01'.Date]
After adding region to the formula, I set the Region context selector to "Global" which includes all regions. I then compared this result to the result of my first formula above and expected the calculations to match perfectly. Since the context selector is set to Global, I expect the results to be the same.
In contrast to me expectation, about 50% of the values are exactly the same and about 50% of the values are different.
Why is this happening?