Unable to formulate CoalesceEmpty() for my requirement

Questions & Answers
1

Hi Team,

I have created measure as follows
Measure Name: Inflow-MTD
Aggregate(
{
[Time].[Month].CurrentDateMember
},[Measures].[Issues created]
)

When we ran this we are getting some blank values, as per the documentation we can get the value as ‘0’ for blank values by using CoalesceEmpty(), but I am unable to formulate it, getting an error.

Can you please help me with this.

Regards
Kasi

2

@kasi.maddula

Try this formula.

CoalesceEmpty((
[Time].[Month].CurrentDateMember,
[Measures].[Issues created]
),0)

Martins / eazyBI team