SQL Server Analysis Services MDX Average Calculation

How can you calculate an average in SQL Server MDX? Can calculating an average in MDX be accomplished in multiple ways? Check out this tip to learn more.

Solution

The solution presented in this tip was created in SQL Server Management Studio. The AVG function in SQL Server MDX allows for the calculation of an average measure over a specified set of dimension values.