Forum Discussion
Dealing with Blank Values
Anonymous - You can't do:
COUNTROWS(FILTER('Table',ISBLANK([Answers]) || [Answers = ""))
Community ChampionAnonymous - If you are trying to count blank values, sometimes you have to check multiple things like
ISBLANK([column]) || [column]=""
Sorry, not super clear on what your issue is, you still want to count the blanks, correct?
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).
- Greg_Deckler
Anonymous - You can't do:
COUNTROWS(FILTER('Table',ISBLANK([Answers]) || [Answers = ""))