COUNT

Applies to: Calculated column Calculated table Measure Visual calculation

Counts the number of rows in the specified column that contain non-blank values.

Syntax

COUNT(<column>)

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

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

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.