September 1, 2004 at 2:44 pm
I am trying to create a calculated measure that is the stddev of another calculated measure (PMPM) from the mean of the entire set of PMPM.
This expression is valid, but returns -1 for every slice.
Stdev
({[Measures].[PMPM]},[Measures].[PMPM])
Any suggestions?
September 1, 2004 at 9:43 pm
I seem to recall that George Spofford in his MDX SOlutions book had a solution for this. You might try googling on "Spofford" and "Standard Deviation"
HTH,
Trey Johnson | Chief Business Intelligence Architect | Cizer Software (www.cizer.com)
Who? - Cizer - http://www.cizer.com/about.htm - Blog - http://www.sqlserverbi.com/
What? - Products enhancing Microsoft Business Intelligence - http://www.cizer.com/products.htm
Wow! - Empower your Developers.... NEW Drop In Reporting - http://www.cizer.com/cnr-drop-in-reporting.htm
How? - BI Training - http://www.cizer.com/training.htm - Cizer Solutions - http://www.cizer.com/solutions.htm
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply