Forum Discussion

chandakaushik's avatar
chandakaushik
Icon for Helper I rankHelper I
7 years ago
Solved

COUNTA 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 ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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.

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

chandakaushik parry2k ,

 

That is interesting. I am getting the same results, however if I load a table from Excel, the counta function works as expected, or rather Excel does not load anything into a blank cell.

 

Nathaniel

 

chandakaushik's avatar
chandakaushik
Icon for Helper I rankHelper I
7 years ago

 , Nathaniel_C  - Yes, you're right Nathaniel. This is surprizing me as well. I don't understand how PBI is rendering blank cells in manually created tables.

parry2k  - I entered the data manually and I'm sure there are no white spaces in the table. It's not showing null for blank cells in Power Query. When I use ISBLANK(TRIM([Address])), it still returns FALSE.