DAX Aggregation - AVERAGE function


Advertisements

Description

Returns the average (arithmetic mean) of all the numbers in a column.

Syntax

AVERAGE (<column>)

Parameters

Sr.No. Parameter & Description
1

Column

The column that contains the numbers for which you want the average.

Return Value

Returns a decimal number that represents the arithmetic mean of the numbers in the column.

Remarks

  • If the column contains logical values or empty cells, those values are ignored and the rows are not counted.

  • Cells with the value zero are included and the rows are counted for the divisor.

  • Whenever there are no rows to aggregate, the function returns a blank. However, if there are rows, but none of them meet the specified criteria, the function returns 0.

Example

= AVERAGE (Sales[Sales Amount]) 
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