SSAS - AverageOfChildren only applies to the time dimension

I've just spent a morning trying to figure out why my average measure doesn't average but sums.

I guess I should have googled straight away. In doing so I found this forum post

Christian also mentions this behaviour but only for the other semi additve measures, It does also apply to the AverageOfChildren measure as well

To get wrong this I created a simple calculated measure by going into the calculations tab. Clicking New Calculated Member, giving it a name and then putting in an expression like,

[Measures].[Sum Of Ping Duration]/[Measures].[Pingstat Count]

Where the [Sum Of Ping Duration] is the sum of the measure I want the average for and Pingstat Count is the number of instances of the measure.

I don't think you need to put in some divide by 0 handling because if the count is 0 then the duration will be empty and so won't be calculated.

Happy to be told the best way to do this.

Update: I've just read Mosha's post on averages which is much more detailed and a very good read.

Published 21 May 2007 12:08 by simonsabin
Filed under: ,


02 June 2010 21:35 by wildfire scooter review blogs

# wildfire scooter review blogs

A Malaysian citizen by the name of Anwar Ibrahim was taken into police today, 16th of July, 2008, at about 1pm local time in Kuala Lumpur by a large team of police office that also comprise a group of police special action force, that is police commando