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,
[Priority].[Emergency])

image

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

Exactly,Thank you for your great reply !!!