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
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir