Aggregation functions in Power BI (using DAX) are used to summarize data. They help you calculate totals, counts, and averages from large datasets, making reports easier to analyze and understand.<\/p>\n\n\n\n
These functions are commonly used inside Measures to create dynamic calculations.<\/p>\n\n\n\n
The SUM function adds all the values in a numeric column.<\/p>\n\n\n\n
SUM(Table[Column])<\/pre>\n\n\n\nExample<\/h3>\n\n\n\n
Total Sales = SUM(Sales[Amount])<\/pre>\n\n\n\nThis measure calculates the total of all values in the Amount column of the Sales table.<\/p>\n\n\n\n
When to Use SUM<\/h3>\n\n\n\n
\n
- To calculate total revenue<\/li>\n\n\n\n
- To calculate total quantity sold<\/li>\n\n\n\n
- To get total expenses or costs<\/li>\n<\/ul>\n\n\n\n
COUNT Function<\/h2>\n\n\n\n
The COUNT function counts the number of non-blank values in a column.<\/p>\n\n\n\n
Syntax<\/h3>\n\n\n\n
COUNT(Table[Column])<\/pre>\n\n\n\nExample<\/h3>\n\n\n\n
Total Orders = COUNT(Sales[OrderID])<\/pre>\n\n\n\nThis measure counts how many non-empty OrderID values exist in the Sales table.<\/p>\n\n\n\n
Related Functions<\/h3>\n\n\n\n
\n
- COUNTA \u2013 Counts non-blank values (including text)<\/li>\n\n\n\n
- COUNTROWS \u2013 Counts the total number of rows in a table<\/li>\n<\/ul>\n\n\n\n
Example:<\/p>\n\n\n\n
Total Rows = COUNTROWS(Sales)<\/pre>\n\n\n\nAVERAGE Function<\/h2>\n\n\n\n
The AVERAGE function calculates the average (mean) of a numeric column.<\/p>\n\n\n\n
Syntax<\/h3>\n\n\n\n
AVERAGE(Table[Column])<\/pre>\n\n\n\nExample<\/h3>\n\n\n\n
Average Sales = AVERAGE(Sales[Amount])<\/pre>\n\n\n\nThis measure calculates the average sales amount.<\/p>\n\n\n\n
When to Use AVERAGE<\/h3>\n\n\n\n
\n
- To calculate average revenue per order<\/li>\n\n\n\n
- To find average salary<\/li>\n\n\n\n
- To measure average performance metrics<\/li>\n<\/ul>\n\n\n\n
Important Concept: Filter Context<\/h2>\n\n\n\n
All aggregation functions in Measures respond to filter context. This means results will change automatically when you apply slicers, filters, or use different visuals in your report.<\/p>\n\n\n\n
For example, Total Sales will show different values when filtered by year, region, or product.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
SUM, COUNT, and AVERAGE are basic but powerful aggregation functions in DAX. They form the foundation of most business reports and dashboards. Mastering these functions is essential for creating meaningful and dynamic Power BI reports.<\/p>\n\n\n\n
<\/strong><\/p> <\/div> <\/div>\n\n\n