Forum Discussion
chandakaushik
Helper I
Helper ICOUNTA function is counting blank cells as well
Did anyone notice that COUNTA DAX function is counting blank cells in the column as well? Microsoft's documentation says it counts the number of cells in a column that are not empty. Any idea what's ...
that's what is looks like, and only reason you need to do that because you are using COUNTA or similar function which doesn't count BLANK otherwise you can always put condition in your measure to check for whitespace and blank() but replace can be more elegant solution.
parry2k
Super User
Super Userchandakaushik can you share sample dataset, what you are trying to do and what is not working? If it actually BLANK() or empty value in text field.
here is post on more detail on BLANK