Skip to main content

NonEmpty

Returns the non-empty tuples from a set, based on the cross product of the set with a measure.

Syntax​

NonEmpty(Set_Expression, Measure)

Input parameters​

Set_Expression
An MDX expression that returns a set.

Measure
A fully qualified measure reference; for example, [Measures].[Internet Sales Amount Local].

Return value​

The non-empty tuples from a set, based on the cross product of the set with a measure.

Example​

NonEmpty( Tail( Descendants( [DateCustom].[StandardMonth].CurrentMember, [DateCustom].[StandardMonth].[Month] ), 2 ), Measures.[Internet Sales Amount Local] )