Statistical Functions (DAX)

Data Analysis Expressions (DAX) provides many functions for creating aggregations such as sums, counts, and averages. These functions are very similar to aggregation functions used by Microsoft Excel. This section lists the statistical and aggregation functions provided in DAX.

In This Section

ADDCOLUMNS Function (DAX)

AVERAGE Function

AVERAGEA Function

AVERAGEX Function

COUNT Function

COUNTA Function

COUNTAX Function

COUNTBLANK Function

COUNTROWS Function (DAX)

COUNTX Function

CROSSJOIN Function (DAX)

DISTINCTCOUNT Function (DAX)

GENERATE Function (DAX)

GENERATEALL Function (DAX)

MAX Function

MAXA Function

MAXX Function

MINA Function

MIN Function

MINX Function

RANK.EQ Function (DAX)

RANKX Function (DAX)

ROW Function (DAX)

SAMPLE Function (DAX)

STDEV.P Function (DAX)

STDEV.S Function (DAX)

STDEVX.P Function (DAX)

STDEVX.S Function (DAX)

SUMMARIZE Function (DAX)

TOPN Function (DAX)

VAR.P Function (DAX)

VAR.S Function (DAX)

VARX.P Function (DAX)

VARX.S Function (DAX)

Reference

Data Analysis Expressions (DAX) Overview

DAX Syntax Specification for PowerPivot

Related Sections

Date and Time Functions (DAX)

Statistical Functions (DAX)

Logical Functions (DAX)

Filter Functions (DAX)

Math and Trig Functions (DAX)

See Also

Concepts

Data Analysis Expressions (DAX) Overview