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.
try the COALESCE function to convert BLANK (empty) values in your measure to 0.