Search code examples
powerpivotdax

Getting DAX to return 0 instead of Blank

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?

Solution

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

    Data with only "A" and "B":

    data

    Before:

    before

    After adding + 0:

    after