Returns the count of the number of tuples in a set that evaluate to non #Missing values.
Syntax
NonEmptyCount ( set [,numeric_value_expression ] )
Parameter | Description |
---|---|
The set in which to count tuples. | |
numeric_value_expression | Optional expression (see MDX Grammar Rules). |
Notes
Each tuple is evaluated and included in the count returned by this function. If the numeric value expression is specified, it is evaluated in the context of every tuple, and the count of non #Missing values is returned.
Example
The following query
With Member [Measures].[Number Of Markets] as 'NonEmptyCount (Market.Levels(0).Members, Sales)' Select {[Measures].[Number Of Markets]} on Columns, {[100].Children, [200].Children} on Rows FROM Sample.Basic
Returns the grid:
(axis) | Number of Markets |
---|---|
100-10 | 20 |
100-20 | 16 |
100-30 | 8 |
200-10 | 20 |
200-20 | 17 |
200-30 | 9 |
200-40 | 3 |