IsEmpty

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