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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements