Search

DAX Aggregation Functions

Name
Syntax
Return
Description
Status

SUM(<column>)

Decimal number (scalar)

Adds all numbers in a column. Operates in filter context and ignores blank values and text

Done

AVERAGE(<column>)

Decimal number (scalar)

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

Done

MIN(<column>)

Scalar value

Returns the smallest value in a column

Done

MAX(<column>)

Scalar value

Returns the largest value in a column

Done

PRODUCT(<column>)

Decimal number (scalar)

Returns the product of the numbers in a column.

Done

AVERAGEA(<column>)

Decimal number (scalar)

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

Done

MAXA(<columnName>)

Scalar value

Returns the largest value in a column

Done

MINA(<column>)

Scalar value

Returns the smallest value in a column, including any logical values and numbers represented as text.

Done

COUNT(<column>)

Whole number (integer)

Counts the number of rows in the specified column that contain non-blank values

Done

COUNTA(<column>)

Whole number (integer)

Counts the number of rows in the specified column that contain non-blank values. Supports Boolean values.

Done

COUNTBLANK(<column>)

Whole number (integer)

Counts the number of blank cells in a column.

Done

COUNTROWS(<table>)

Whole number (integer)

Counts the number of rows in the specified table, or in a table defined by an expression.

Done

DISTINCTCOUNT(<column>)

Whole number (integer)

Counts the number of distinct values in a column

Done

DISTINCTCOUNTNOBLANK(<column>)

Whole number (integer)

Counts the number of distinct values in a column.

Done

APPROXIMATEDISTINCTCOUNT(<column>)

Whole number (integer)

Returns an estimated count of unique values in a column.

Done

SUMX(<table>, <expression>)

Decimal number (scalar)

Returns the sum of an expression evaluated for each row in a table

Done

AVERAGEX(<table>, <expression>)

Decimal number (scalar)

Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.

Done

COUNTX(<table>, <expression>)

Whole number (integer)

Counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table.

Done

COUNTAX(<table>, <expression>)

Whole number (integer)

Counts non-blank results when evaluating the result of an expression over a table.

Done

MAXX(<table>, <expression>)

Scalar value

Evaluates an expression for each row of a table and returns the largest numeric value.

Done

MINX(<table>, <expression>)

Scalar value

Returns the smallest numeric value that results from evaluating an expression for each row of a table.

Done

PRODUCTX(<table>, <expression>)

Decimal number (scalar)

Returns the product of an expression evaluated for each row in a table.

Done