The MDX CoalesceEmpty function returns the first (from the left) non #Missing value from the given value expressions.
CoalesceEmpty ( numeric_value_expression1, numeric_value_expression2 )
A numeric value expression.
A numeric value expression.
with
member measure.AAA as CoalesceEmpty((measure.[cash back]), (measure.[sales quantity]))
select
{ (measure.[sales quantity]), (measure.[cash back]), (measure.AAA) } on 0,
{ (Calendar.[ALL]) } on 1
from [Online Store] ;
| sales quantity | cash back | AAA | |
| ALL | 908584 | 0 | 908584 |