ISEMPTY

The ISEMPTY function evaluates if a cell in a cube is empty or not.

Syntax

ISEMPTY(value_expression)

Return Value

Returns true if the evaluated expression is an empty cell, otherwise returns false.

Input Parameters

value_expression
Required. A valid Multidimensional Expressions (MDX) expression that typically returns the cell coordinates of a member or a tuple.

Examples

A very common use of IsEmpty is to handle 'division by zero' errors within calculated measures. Get the Sales for a month, and calculate it's contribution to the total year's sales:

IIF ( IsEmpty ( [Measures].[Yearly Sales] ) , NULL , ( [Measures].[Monthly Sales] / [Measures].[Yearly Sales] ) )