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.ISEMPTYDEMO AS
IsEmpty([Measures].[Internet Sales Amount])
SELECT {[Measures].[Internet Sales Amount],MEASURES.ISEMPTYDEMO} ON 0,
[Date].[Fiscal].MEMBERS ON 1
FROM [AdventureWorksMF]