MDX Aggregate Functions Can Not Be Used on Calculated Members in the Measures Dimension

Written by Dustin Ryan on 29 June 2011. Posted in MDX

If you've ever tried to use the Aggregate function on a calculated measure, you've seen the following error:

Query(3,1) Aggregate functions cannot be used on calculated members in the Measures dimension.