The COUNT function counts the number of cells in a column that contain non-blank values.




Term Definition
column The column that contains the values to be counted.

Return value

A whole number.


The only argument allowed to this function is a column. The COUNT function counts rows that contain the following kinds of values:

  • Numbers

  • Dates

  • Strings

When the function finds no rows to count, it returns a blank.

Blank values are skipped. TRUE/FALSE values are not supported.

If you want to evaluate a column of TRUE/FALSE values, use the COUNTA function.


The following example shows how to count the number of values in the column, ShipDate.


To count logical values or text, use the COUNTA or COUNTAX functions.

See also

COUNTA function (DAX)
COUNTAX function (DAX)
COUNTX function (DAX)
Statistical functions (DAX)