How to combine these two formula to one condition?

[Charles]

Dear,

One Formula:

CASE WHEN NOT isEmpty([Measures].[Issues created])
THEN Val([Measures].[Issues created])
ELSE 0
END

One Formula:
Aggregate(Filter([Issue].[Issue].Members,
[Measures].[Issue type]= “Bug”)
)

I want to use one measure to perform these two formula function.

Thanks a lot!

[martins.vanags]

Hi,

I believe you can find the solution in this community post:

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]

Anyway, try this code:

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

Martins / eazyBI support

[Charles]

YES, the problem is resolved by your method.