DAX function
COUNT — DAX function reference
Count numeric values.
Syntax
dax
COUNT(<column>)
Examples
dax
COUNT(Sales[OrderID])
→ A number
dax
CALCULATE(COUNT(Sales[OrderID]), Sales[Amount] > 0)
→ Count of positive-amount rows
dax
COUNT(Sales[Discount])
→ Counts only rows where Discount is non-blank and numeric
Common mistakes & gotchas
- COUNT only counts numeric, date, or currency values and skips blanks — it silently under-counts on text or mixed-blank columns; use COUNTA for text or COUNTROWS to count every row regardless of value.
Related DAX functions
From Aggregations