# 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.

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.