Created
January 25, 2015 10:46
-
-
Save osya/df12b8633e0e78ef7907 to your computer and use it in GitHub Desktop.
MDX Calculated Member example for Debugging another Calculated Member #MDX
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| MEMBER [Measures].[Proof] AS iif( IsEmpty( [Measures].[Order Count] ), null, iif( IsLeaf( [Date].[Fiscal Weeks].CurrentMember ), [Measures].[Order Count], '( ' + Generate( [Date].[Fiscal Weeks] .CurrentMember.Children, iif( IsEmpty( [Measures] .[Average of an average] ), '(null)', CStr( Round( [Measures] .[Average of an average], 0 ) ) ), ' + ' ) + ' ) / ' + CStr( NonEmpty( [Date].[Fiscal Weeks] .CurrentMember.Children, [Measures].[Order Count] ).Count ) ) ) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment