- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Aggregation - COUNTA function
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