Skip to main content
Version: I2024.2.x

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] )