COUNT Function (DAX)

How does the COUNT function (DAX) work?

The COUNT function counts the number of cells in a column with a non-blank value.

COUNT Formula Syntax

COUNT(
     <column>
)

How do you use the COUNT function?

The COUNT function is used to count up all the rows in a given column but it will not count blank or empty rows.

Related Blog Posts

Related Support Forum Posts

How to Count Text Values in Power BI like COUNTA in excel
COUNTIF Equivalent for Power BI, which DAX function to Use?
Question with one of the curriculum videos

Considerations when using the COUNT function

This function has only one argument, which is a column. The rows contain any of the following values: numbers, dates, or strings.If it has no rows to count, this function returns a blank. Blank values are skipped, while TRUE/FALSE values are not supported.

Related Video Tutorials

ACOSH Function (DAX)

Formula examples using the COUNT function

=COUNT([ShipDate])

=COUNT(B5:B11)

=COUNT(1,2,”apple”)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership