I have a problem to calculate the variance.
Here is the code I use:
Dynamically, the calculated measure makes the subtraction between the first measure and the second measure.
On the other hand, when that I add dimensions, an error displays.
Thank you very much.
The axis function seems like overkill for the requirement. How about :
WITH Member [Measures].[ItemVariance] as
[Measures].[Name of First Measure] - [Measures].[Name of Second Measure]
I wonder about it being called variance though. Variance is a statistical value related to standard deviation (standard deviation squared).
Subtracting one from the other would be the "difference".