Count of Blank values in a text field is wrong

[Anonymous]

Hi,

I have a csv file with about 21,000 rows and there is a text column called application names which has 15486 blank rows when i check in excel, but in my measure for CountBlank i.e. = COUNTBLANK('Projects_All'[Application Names]) i am getting a value of 6338. Also i checked in the visual filters and that shows the same value. But i dont get why its not detecting the remaining blank rows?

Thanks in advance 🙂

[Anonymous · Accepted solution]

Hi everyone,

It was my bad, there was a date filter set at page level which was affecting the count, Also i choose to use lEN rather than checking for blank rows.

Thanks for all your replies 🙂

[v-yulgu-msft]

Hi @Anonymous,

Please try this measure to see whether it returns correct number.

BlankRows = 
CALCULATE ( COUNTROWS ( Projects_All ), Projects_All[Application Names] = BLANK () )

Did you apply any filter to data records? And please check are there some rows missing after loading to desktop.

As I could not reproduce your problem, if possible, please share your .pbix file.

Regards,
Yuliana Gu

[BILASolution]

Hi @Anonymous

Try this...

CountBlank i.e. = CALCULATE(COUNTBLANK('Projects_All'[Application Names]);ALL('Projects_All'))

Regards

BILASolution