COUNTBLANK DAX Function in Power BI

The COUNTBLANK DAX function counts the number of blank cells in a column.

DAX Syntax COUNTBLANK([column])

The parameter column specifies the column name from which we want to find the blank values.

Example: Let’s create a measure for counting the blank values in the MyBranch column.

Suppose we have the following table:

COUNTBLANK dax function in Power BI

DAX

Blank values in a Column = COUNTBLANK(Sheet1[MyBranch])

The output of the above code is shown below:

COUNTBLANK dax function in Power BI