COUNTBLANK is a DAX function that counts the number of blank values in a column.
Syntax
COUNTBLANK( ColumnName )| Argument | Properties | Description |
|---|---|---|
| ColumnName | The column containing the blanks to be counted. |
COUNTBLANK
Updated on
COUNTBLANK is a DAX function that counts the number of blank values in a column.
COUNTBLANK( ColumnName )| Argument | Properties | Description |
|---|---|---|
| ColumnName | The column containing the blanks to be counted. |
A whole number. If no rows are found that meet the condition, blanks are returned.
The only argument allowed to this function is a column. You can use columns containing any type of data, but only blank cells are counted. Cells that have the value zero (0) are not counted, as zero is considered a numeric value and not a blank.
Whenever there are no rows to aggregate, the function returns a blank. However, if there are rows, but none of them meet the specified criteria, the function returns 0. Microsoft Excel also returns a zero if no rows are found that meet the conditions.
In other words, if the COUNTBLANK function finds no blanks, the result will be zero, but if there are no rows to check, the result will be blank.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following example shows how to count the number of rows in the table Reseller that have blank values for BankName.
= COUNTBLANK(Reseller[BankName])
To count logical values or text, use the COUNTA or COUNTAX functions.
Other functions related to COUNTBLANK are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy