إشعار
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تسجيل الدخول أو تغيير الدلائل.
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تغيير الدلائل.
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 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])