Sometimes when certain values are not available, in a table I want to show text instead of the numeric outcome.
How do I do this with MDX?
You can use the case statement to check first whether the value is empty. An example can be found here: https://community.eazybi.com/t/blank-field-need-to-have-existing-value/3702/2
Now, you may get some format errors since youbare mixing numbers and string values, so you may have to convert the numeric value to a string.