How to display "0" in an empty cell

When I use the tuple method to display the bug creation report

([Measures].[Issues created], [Issue Type].[Bug])

Some days did not create a bug,I want the corresponding cell to display “0”, Can you please help us ?

Please refer below set of code

IIF(IsEmpty(([Measures].[Issues created],[Priority].[Emergency])),0,

This will see if there is a empty cell, then the empty cell will be replaced as zero.

Hope this helps.

1 Like

Great, thanks for the support!


There is a standard function CoalesceEmpty in the MDX which can make the same code provided earlier more compact:

CoalesceEmpty([Measures].[Issues created],0)

Janis, eazyBI support

Hi everybody,
How can I make the inverse?
I wanna display an empty cell when I find a 0 in the row.
I’m trying to use the Hide empty rows for having a report with no missing data.


You can use
NonZero(<your statement>)