The MDX IsEmpty function returns TRUE if the value of an input numeric-value-expression evaluates to #MISSING, and returns FALSE otherwise.
IsEmpty ( value_expression )
A set returning values to check for emptiness.
Zero is not equivalent to #MISSING. IsEmpty(0) returns TRUE.
with
member [Measures].CUSMBR as IIf(IsEmpty([Measures].Revenue), 0, [Measures].Revenue)
select
Children([Date].[2022].[Q3]) on 1,
{
[Measures].Revenue,
[Measures].CUSMBR
} on 0
from [Airline A]
where
([Classes of Service].[Premium Business], [Aircraft Models].[Boeing].[Boeing 737]);
| Revenue | CUSMBR | |
| M7 | 0.00 | |
| M8 | 361450.00 | 361450.00 |
| M9 | 253180.00 | 253180.00 |