calculating avg 1

[danabb]

Hi,

im trying to add a calculated member (measure) to give me the avg sales - the syntax goes like this :

Avg([Items].[Category].Members) the syntax is ok but i'm getting an error in the cube.

 

[ram1975]

Best way to get average in analysis services is to add a measure with sum as aggregate formula. Add same measure again with count as aggeregate formula. Then use a calculated measure with sum/count to get the average.