COUNT

Counts the number of rows in the specified 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.

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

  • For best practices when using COUNT, see Use COUNTROWS instead of COUNT.

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.

COUNTA function
COUNTAX function
COUNTX function
Statistical functions