Forum Discussion
Solved
Dealing with Blank Values
Hi everyone, I´m currently working on a NPS Report on Power Bi and i´m having trouble with counting blank values. Here´s my problem; i have 2 tables, one for the surveys sent and another one for ...
andresgl06 - You can't do:
COUNTROWS(FILTER('Table',ISBLANK([Answers]) || [Answers = ""))
I think i failed at explaining my issue. Here´s the field "Answers" with all the possibles values it could have (from 0 to 10). When i count the answers i count the different ID's for the surveys that have a value on this field and that works well, but the blank values wich are the surveys that were not answered i can´t seem to count them. I´ve tried different things and so far my results are; getting a total surveys that doesn´t change with my date slicer, or get nothing as result (the measure doesnt show anything).
andresgl06 - You can't do:
COUNTROWS(FILTER('Table',ISBLANK([Answers]) || [Answers = ""))