Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
axy5093
Helper II
Helper II

Count of Blank values in a text field is wrong

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 🙂

1 ACCEPTED SOLUTION
axy5093
Helper II
Helper II

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 🙂

View solution in original post

3 REPLIES 3
axy5093
Helper II
Helper II

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
Employee
Employee

Hi @axy5093,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BILASolution
Solution Specialist
Solution Specialist

Hi @axy5093

 

Try this...

 

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

Regards

BILASolution

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.