AVG

Description:

This function is used to evaluate a set and returns the average of the non-empty values of the cells in the set, averaged over the measures in the set or over a specified measure.

Syntax:

Avg( Set_Expression [ , Numeric_Expression ] )

Return Type:
SCALAR

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.
Numeric_Expression	A valid numeric expression is typically an MDX expression of cell coordinates that returns a number.

Example:

WITH MEMBER 
  [Measures].[Average] AS
   Avg (
        [Customer].[Geography].[Country],
	[Measures].[Reseller Sales Amount]
       ) 

SELECT 
  [Measures].[Average] ON COLUMNS,
  {
   [Product].[Product Categories].[Category]