I have a calculated measure that is based on two other measures. It is pretty close to this:
WHEN [Measures].[SkipUnits] > [Measures].[Units] THEN null
ELSE [Measures].[Units] - [Measures].[SkipUnits]
Obviously, I need to reduce my units by my skipped units but the units calculation cannot be less than zero.
This is all dandy until this measure is used by a calculation showing the variance between this year and last year (or any other variance). In these cases, I want the calculated measure to calculate first and then the variance calculated because it is ok to have a negative variance.
Anyone have a way of doing this that does not involve specifying the calculation for this measure manually for each of the variance calculations? Unfortunately, I have a lot of them.