COUNTBLANK DAX function is used to counts the number of blank cells in a column. This function comes under Statistical Functions DAX category.
|1||column||The column that contains the blank cells to be counted.|
Dataset format as below:
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
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.
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.