The COUNTBLANK function counts the number of cells containing Blank values in a column.
Syntax
COUNTBLANK(
<column>
)
Parameters
- column: Column in which to count.
Returned value
The COUNTBLANK function returns an integer.
Additional Information
The indicated column can be of any type, although only cells containing Blanks will be counted.
Cells containing zero or empty text strings are not considered Blank.
If there are no rows to count, the function returns a Blank. If no empty cells are found, the function returns zero.
Examples
We can count the number of clients that do not have a "middle name" with the following measure:
Number of blanks = COUNTBLANK(Customer[MiddleName])
Category
Statistical