ISEMPTY
The ISEMPTY
function evaluates if a cell in a model 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] ) )