I've a question around the use of the MAX() function in MDX.
What I want to do is to configure a calculated measure named [Peak Value] which is the maximum value of another measure across the shown set of Months.
Month Measure Peak Value
Jan 15 27
Feb 19 27
Mar 27 27
Apr 10 27
The issue I have is that the max value will be taken across all members at the current member level and not just the set being viewed in the browser or Excel. I.e. if Novemeber has a measure value of 30 this will be displayed instead of the requied value of 27.
I'm hoping there is a simple solution to this, so any help would be greatly appreciated.
Thanks in advance,
View Complete Post