Average Function Affected by Hierarchy

Options
MattRobinson
MattRobinson Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & Modeling

Hi, 

 

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?

Tagged:

Comments

  • MattRobinson
    MattRobinson Member, ALL USERS Posts: 5 Occasional Contributor

    Hi Rob,

     

    I have a hierarchy with Regions rolling up to Global.

     

    Job code is not part of that hierarchy, it is just a dimension of the module I am building. Basically, the rows are job codes.

     

    Time is coming from a "DATE"  column in the source data. Currently, I have IDs as the rows and various columns, including Date.

     

    Best,

    Matt

Categories