Calculate YES and avoid BLANK in a widget

[Richard_Lemkhar]

Hello

I am trying to calculate the number of YES in a column using the below formulas

Count of ATDUsed for YES =

CALCULATE(COUNTA('Run List'[ATDUsed]), 'Run List'[ATDUsed] IN { "YES" })

but when there is no YES the widget is showing BLANK where i wants 0

Can you please help

[Richard_Lemkhar]

Thank you Amal. much appreciated

[parry2k]

@Richard_Lemkhar this:

Count of ATDUsed for YES =
COALESCE (
CALCULATE(COUNTA('Run List'[ATDUsed]), 'Run List'[ATDUsed] IN { "YES" }),
0
)

[Richard_Lemkhar]

can you please show me how to do that ? no a big expert on Power BI

[Amal-RB]

Richard: it would be like this : COALESCE (CALCULATE(COUNTA('Run List'[ATDUsed]), 'Run List'[ATDUsed] = "YES" ),  0)

[Amal-RB · Accepted solution]

try the COALESCE function to convert BLANK (empty) values in your measure to 0.