COUNT

How to Use the Power BI DAX function COUNT

Understanding the COUNT Function

The COUNT function is a DAX function used to count the number of rows in a given table or a column. It returns the total number of values that are not empty or NULL. The COUNT function is often used in combination with other functions in Power BI to perform complex calculations.

Syntax of COUNT Function

The syntax of the COUNT function is as follows:


COUNT(❰expression❱)


Here, the expression can be a column, table, or any other DAX expression that returns a table or a column. The COUNT function counts the number of rows in the resulting table or column.

Using COUNT in Power BI

Let's explore some of the use cases where the COUNT function can be used in Power BI.

Counting Rows in a Table

To count the number of rows in a table, you can use the following formula:


RowCount = COUNTROWS(Table)


Here, Table is the name of the table for which you want to count the rows. The COUNTROWS function returns the total number of rows in the table.

Counting Non-Empty Values in a Column

To count the number of non-empty values in a column, you can use the following formula:


NonEmptyCount = COUNTA(Table[Column])


Here, Table is the name of the table that contains the column, and Column is the name of the column for which you want to count the non-empty values. The COUNTA function counts the number of cells in the column that are not empty.

Counting Unique Values in a Column

To count the number of unique values in a column, you can use the following formula:


UniqueCount = DISTINCTCOUNT(Table[Column])


Here, Table is the name of the table that contains the column, and Column is the name of the column for which you want to count the unique values. The DISTINCTCOUNT function returns the number of unique values in the column.

Using COUNT in Combination with Other Functions

The COUNT function can be used in combination with other DAX functions to perform complex calculations. For example, you can use the COUNT function with the IF function to count the number of rows that meet a certain condition. Here's an example:


CountIf = COUNTROWS(FILTER(Table, Table[Column] ❱ 0))


Here, Table is the name of the table that contains the column, and Column is the name of the column for which you want to count the rows that meet the condition. The FILTER function returns a filtered table that contains only the rows that meet the condition. The COUNTROWS function then counts the number of rows in the filtered table.

The COUNT function is a powerful tool that can help you count the number of rows in a table or a column in Power BI. With the help of other DAX functions, you can use the COUNT function to perform complex calculations and analysis on your data. We hope this article has helped you understand how to use the COUNT function in Power BI.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

15-17 July 2024
16-18 September 2024
11-13 November 2024

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)