Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: Calculated column Calculated table Measure Visual calculation
Counts the number of rows in the specified column that contain non-blank values.
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:
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.
COUNTA function COUNTAX function COUNTX function Statistical functions
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today