COUNTA

The COUNTA function returns the number of cells in a column that are not blank. That is, it counts not only numeric values, texts, and dates like the COUNT function, but it also counts logical values.

Syntax

COUNTA(
    column
)

Parameters
  • column: Column whose values you want to count.
Returned value

The COUNTA function returns an integer.

Additional Information

If the function does not find any rows to count, it returns a blank. When there are rows, but none meet the expected requirements, the function returns 0.

Examples

In this example we are creating a measure that counts the number of customers with some data in the Customer[Phone] field:

Customers with phone number = COUNTA(Customer[Phone])

COUNTA function. Example of use
Related functions
Category
Statistical
Submitted by admin on Thu, 01/10/2019 - 15:10