How to display empty cell to 0?

Why the measure can’t display the 0? Is it correct?

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

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


Hi Charles,

You can try using CoalesceEmpty function to show 0 instead of empty values.

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

Martins / eazyBI support

1 Like

Exactly,Thank you for your great reply !!!