Count Blank Rows in a Table

[Anonymous]

Hi,

Is there a simple measure that counts all blank rows in a table? Additionally, is there a measure that counts all duplicates in a table? 

Any advice is much appreciated.

Cheers

Nathan

[amitchandak]

@Anonymous , You have a function countblank for column.

https://docs.microsoft.com/en-us/dax/countblank-function-dax

Do want count complete blank row ?

[Anonymous]

Thank you for the reply @amitchandak !!

I understand there is a countblank funtion, but i'm not needing to count blank rows in a column, i need to count the number of blank rows in my entire table. Would you know what to do?

[amitchandak · Accepted solution]

@Anonymous , Try like

COUNTROWS(ALL('DateTime')) - COUNTROWS(ALLNOBLANKROW('DateTime'))

COUNTROWS(ALL('Table')) - COUNTROWS(ALLNOBLANKROW('Table'))

Refer

https://docs.microsoft.com/en-us/dax/allnoblankrow-function-dax

[Anonymous]

Thank you again @amitchandak,. This does work, however i realise it is calculating whether the row is entirelly blank. I'm looking for a measure that calculates how many blank cells there are in a table. 

I hope this makes sense, i did word the initial question wrong so i will mark your reply as a solution.  If you are able to advice me on how to count the number of blank cells in a table that would be great. 

Cheers

Nathan 

[amitchandak]

@Anonymous , Multiple by No of columns.  [Blank Rows] * no of columns

Or countblank(Table[Col1])+ countblank(Table[Col2])+ countblank(Table[Col3) + countblank(Table[Col4]) + .....

[amitchandak]

@Anonymous , do you need more help on this