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 number of Blank rows under “Blank” Column. So for this create one new measure.
COUNTBLANK = COUNTBLANK(SampleTable[Blank])
Above measure will return no of blank rows under “Blank” column is 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 id column there is no blank row so it will return 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.