DAX Aggregation - COUNTA function
Advertisements
Description
Counts the number of cells in a column that are not empty. It counts not just the rows that contain numeric values, but also the rows that contain nonblank values, including text, dates, and logical values.
Syntax
COUNTA (<column>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
column The column that contains the values to be counted. |
Return Value
Returns a whole number.
Remarks
When the function does not find any rows to count, the function returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.
Example
= COUNTA (ProductInventory[UsageDate])
dax_functions_aggregation.htm
Advertisements