Forum Discussion
Solved
Calculate YES and avoid BLANK in a widget
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" }) ...
try the COALESCE function to convert BLANK (empty) values in your measure to 0.
can you please show me how to do that ? no a big expert on Power BI
Richard: it would be like this : COALESCE (CALCULATE(COUNTA('Run List'[ATDUsed]), 'Run List'[ATDUsed] = "YES" ), 0)