COUNTA is a DAX function that counts the number of values in a column.
Syntax
COUNTA( ColumnName )| Argument | Properties | Description |
|---|---|---|
| ColumnName | The column that contains the values to be counted. |
COUNTA
Updated on
COUNTA is a DAX function that counts the number of values in a column.
COUNTA( ColumnName )| Argument | Properties | Description |
|---|---|---|
| ColumnName | The column that contains the values to be counted. |
A whole number.
When the function does not find any rows to count, the function returns a blank.
Unlike COUNT, COUNTA supports Boolean data type.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following example returns the number of all rows in the Reseller table that have any kind of value in the column that stores phone numbers.
= COUNTA(Reseller[Phone])
Other functions related to COUNTA are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy