Getting DAX to return 0 instead of Blank

Question

Using PowerPivot and DAX Countrows along with filter option with a column that has six possible expressions. (Excellent, Good, Acceptable, Not good, Poor and Blank). Post count, I am calculating Satisfaction percentage by Dividing Excellent and Good by the Total responses. My problem is that the countrows function does not take blank as 0 and thus screws up my calculation. How do I get around this?

Answer 1

A simple yet effective trick I've always used: add + 0 to your measure.

Data with only "A" and "B":

Before:

After adding + 0: