COUNT

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

Syntax

COUNT(<column>)  

Parameters

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

Return value

A whole number.

Remarks

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.

Example

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

=COUNT([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)