DAX in Power BI for Data Science & Analytics

DAX Aggregation Functions

Learn how to use DAX aggregation functions including SUM, AVERAGE, MIN, MAX, COUNT, COUNTROWS, and DISTINCTCOUNT to turn Power BI data into meaningful analytics and business metrics.

Interactive Concepts

Related MCQs

Question

Function

Question

Function

Total?

SUM

Average?

AVERAGE

Smallest?

MIN

Largest?

MAX

Rows?

COUNTROWS

Unique?

DISTINCTCOUNT

Question 1 of 8

13%

CurrentCompletedLocked

QUESTION 1

Why Aggregation Functions Matter

Aggregation functions turn many rows of data into useful analytical numbers such as total sales, average revenue, highest transaction, or number of orders.

From rows to a business metric

Real-world business datasets often contain hundreds, thousands, or millions of rows. A manager usually does not want to inspect every row. They want a useful summary such as total revenue, average order value, highest transaction, or number of customers.

Total Sales = SUM(Sales[Amount])

Aggregation functions summarize many values into an analytical result. Because this is a measure, the result can respond to the current Power BI filter context.

What is the main purpose of an aggregation function?

DAX Aggregation Functions in Power BI

DAX aggregation functions are fundamental to Power BI data analysis. They allow analysts to transform detailed rows into useful business metrics. Common DAX aggregation functions include SUM, AVERAGE, MIN, MAX, COUNT, COUNTROWS, and DISTINCTCOUNT.

SUM and AVERAGE

SUM is commonly used when the business question asks for a total, such as total revenue or total sales. AVERAGE is useful when the question asks for a typical numerical value, such as average order value.

MIN and MAX

MIN identifies the smallest value in a column, while MAX identifies the largest. These functions can help analysts investigate ranges and extreme values.

COUNT, COUNTROWS and DISTINCTCOUNT

COUNT counts non-blank values in a column. COUNTROWS counts rows in a table. DISTINCTCOUNT counts unique values in a column. The distinction becomes important when a business question involves orders, customers, products, or other entities.

Choosing the Right DAX Aggregation

Good DAX analysis starts with the business question. Ask whether you need a total, average, minimum, maximum, row count, or unique entity count. Selecting the correct aggregation function makes your measures easier to understand and your Power BI reports more useful.

What You Learn in This Lesson

• Aggregation thinking in DAX
• SUM for totals
• AVERAGE for mean values
• MIN and MAX for boundaries
• COUNT versus COUNTROWS
• DISTINCTCOUNT for unique entities
• Business-question-to-function mapping
• Practical DAX aggregation decisions