ISEMPTY
Description:
This function is used to return whether the evaluated expression is the empty cell value.
Syntax:
IsEmpty(Value_Expression)
Return Type:
LOGICAL
Parameters:
Parameter | Description |
|---|---|
Value_Expression | It is a valid MDX expression, typically returns the cell coordinates of a member or a tuple. |
Example:
WITH MEMBER [Measures].[Has Sales] AS
IIF(ISEMPTY([Measures].[Internet Sales Amount]), "No Sales", "Has Sales")
SELECT
{[Measures].[Internet Sales Amount], [Measures].[Has Sales]} ON COLUMNS,
[Product].[Product].[Product].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]