How to display empty cell to 0?

[Charles]

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])

[martins.vanags]

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

[Charles]

@martins.vanags

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

Exactly,Thank you for your great reply !!!