filling empty cells with 0

[Anonymous]

Hello,

I would like to fill empty cell with zero, how can I do that? As you see on the picture, I have some empty cells...

This is my measure 

Total Pending =

CALCULATE(

    COUNTROWS('CecCaseDetail H'),

    'CecCaseDetail H'[Case] IN {"New", "Enhanced", "Stand" }

)

[Anonymous]

And for this?

NewCasesPrecCount =

VAR SelectedYear = SELECTEDVALUE('Calendar'[Date].[Year])

RETURN

    CALCULATE(

        COUNT('CecCaseDetail'[CaseID]),

        'CecCaseEvent'[EventID] = 1,

        YEAR('CecCaseEvent'[EventDate]) = SelectedYear,

        'CecCaseEvent'[CecCaseId] = 'CecCaseEvent'[CecCaseId],

        FILTER(

            'CecLeadingCase',

            'CecLeadingCase'[CecCaseId] = 'CecLeadingCase'[CecCaseId]

        )

    )

[AnkitaaMishra]

Similarly @Anonymous , you can use again COALESCE function : 

NewCasesPrecCount =

VAR SelectedYear = SELECTEDVALUE('Calendar'[Date].[Year])

RETURN
COALESCE(

    CALCULATE(

        COUNT('CecCaseDetail'[CaseID]),

        'CecCaseEvent'[EventID] = 1,

        YEAR('CecCaseEvent'[EventDate]) = SelectedYear,

        'CecCaseEvent'[CecCaseId] = 'CecCaseEvent'[CecCaseId],

        FILTER(

            'CecLeadingCase',

            'CecLeadingCase'[CecCaseId] = 'CecLeadingCase'[CecCaseId]

        )

    ),
0
)

[Anonymous]

just add COALESCE? Right?

[Anonymous]

yes it works 🙂

[Anonymous]

It works Thank you.

[AnkitaaMishra · Accepted solution]

Hi @Anonymous , 
Try below code : 
Total Pending =
COALESCE(
CALCULATE(
COUNTROWS('CecCaseDetail H'),
'CecCaseDetail H'[Case] IN {"New", "Enhanced", "Stand"}
),
0
)

Thanks, 
Ankita