COUNTA
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Counts the number of rows in the specified column that contain non-blank values.
Syntax
COUNTA(<column>)
Parameters
Term | Definition |
---|---|
column | The column that contains the values to be counted. |
Return value
A whole number.
Remarks
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.
Example
The following example returns all rows in the Reseller
table that have any kind of value in the column that stores phone numbers.
= COUNTA(Reseller[Phone])
Related content
COUNT function
COUNTAX function
COUNTX function
Statistical functions
Tagasiside
https://aka.ms/ContentUserFeedback.
Varsti tulekul: 2024. aasta jooksul tühistame GitHubi probleemide funktsiooni sisutagasiside mehhanismina ja asendame selle uue tagasisidesüsteemiga. Lisateabe saamiseks vtEsita ja vaata tagasisidet