SQLServerCentral.com / Analysis Services / Data Warehousing / Problem Measure Calculated dynamically (error #VALUE!) / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 07 Dec 2016 10:08:42 GMT20RE: Problem Measure Calculated dynamically (error #VALUE!)http://www.sqlservercentral.com/Forums/Topic1438706-17-1.aspx[quote][b]walter.anto (4/4/2013)[/b][hr]Hello,I have a problem to calculate the variance.Here is the code I use:Axis([Measures]).item(0)-Axis([Measures]).item(1)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.Help !Thank you very much.[/quote]The axis function seems like overkill for the requirement. How about :[code="sql"]WITH Member [Measures].[ItemVariance] as([Measures].[Name of First Measure] - [Measures].[Name of Second Measure])[/code]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".Thu, 04 Apr 2013 22:30:42 GMTdavoscollectiveProblem Measure Calculated dynamically (error #VALUE!)http://www.sqlservercentral.com/Forums/Topic1438706-17-1.aspxHello,I have a problem to calculate the variance.Here is the code I use:Axis([Measures]).item(0)-Axis([Measures]).item(1)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.Help !Thank you very much.Thu, 04 Apr 2013 03:56:55 GMTwalter.anto