Report Portal

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.


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.


Tags: mdx


2007-2015 VidasSoft Systems Inc.