DAX – COUNTBLANK Function

COUNTBLANK DAX function is used to counts the number of blank cells in a column. This function comes under Aggregation Functions DAX category.

Refer similar DAX : COUNTROWS , DISTINCTCOUNT ,  COUNT, COUNTA & COUNTX

Syntax:

COUNTBLANK(<column>)

Description:

S no.	Parameter	Description
1	column	The column that contains the blank cells to be counted.

Dataset format as below:

ID	Amount	Blank	Boolean	SalesDate	Name
1			TRUE	29/5/2020	A
2	1000		FALSE		B
3	2000		TRUE	29/5/2020
4	1000		FALSE	28/5/2020	C

Step-1: Now, we will count the number of blank rows under the “Blank” column. To achieve this, let’s create a new measure.

COUNTBLANK = 
COUNTBLANK(SampleTable[Blank])

The measure above will return the number of blank rows under the “Blank” column as 4.

Step-2: Now try COUNTBLANK DAX with other columns

Count Blank with Amount Column:
COUNTBLANK = COUNTBLANK(SampleTable[Amount]) -----    Output = 1

Count Blank with SalesDate Column:
COUNTBLANK = COUNTBLANK(SampleTable[SalesDate]) ----- Output = 1

Count Blank with Id Column:
COUNTBLANK = COUNTBLANK(SampleTable[ID])

In the "ID" column, there are no blank rows, so the result will be "Blank."

Note:

• The only argument allowed to this function is a column.
• It will return a whole number. If no rows are found that meet the condition, blanks are returned.

Refer similar DAX : COUNTROWS , DISTINCTCOUNT ,  COUNT, COUNTA & COUNTX




Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.