Returns True if the value of an input numeric-value-expression evaluates to #MISSING, and returns FALSE otherwise.
Syntax
IsEmpty ( value_expression )
Parameter | Description |
---|---|
value_expression | A set returning values to check for emptiness. |
Notes
Zero is not equivalent to #MISSING. IsEmpty(0) returns TRUE.
Example
The following example finds all Product, Market combinations for which Sales data exists.
WITH SET [NewSet] AS 'CrossJoin([Product].Children, [Market].Children)' SELECT Filter([NewSet], NOT IsEmpty([NewSet].CurrentTuple)) ON COLUMNS FROM Sample.Basic WHERE {[Sales]}
This query returns the following grid:
100 | ... | 400 | Diet | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
East | West | South | Central | ... | East | West | Central | East | West | South | Central |
27740 | 28306 | 16280 | 33808 | ... | 15745 | 35034 | 33451 | 7919 | 36423 | 18676 | 42660 |