DAX function
COUNTBLANK — DAX function reference
Count blank values.
Syntax
dax
COUNTBLANK(<column>)
Examples
dax
COUNTBLANK(Sales[Notes])
→ A number
dax
DIVIDE(COUNTBLANK(Sales[Notes]), COUNTROWS(Sales))
→ Percent of rows with no note
dax
CALCULATE(COUNTBLANK(Customer[Email]), Customer[Segment] = "Enterprise")
→ Enterprise customers missing an email
Common mistakes & gotchas
- COUNTBLANK treats both true blanks/nulls and empty strings "" as blank for text columns — it does not distinguish between them.
Related DAX functions
From Aggregations