COUNTA
The number of a column's values that are not blank, of any type.
Group: Aggregation. Compatible with DAX.
Syntax
COUNTA ( <column> )| Parameter | Type | Description |
|---|---|---|
column | Column | The column whose values are counted; any type. |
Returns
Whole number. How many of the column's cells are not blank.
Remarks
- The same as
COUNT, except that it also takes a column of TRUE and FALSE values. - When nothing is counted, the result is BLANK.
Examples
Counting names and prices
EVALUATE
ROW (
"Bonds", COUNTA ( Holdings[Bond] ),
"Prices", COUNTA ( Holdings[Price] )
)| Bonds | Prices |
|---|---|
| 5 | 3 |