Statistical functions

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

APPROXIMATEDISTINCTCOUNT

AVERAGE

AVERAGEA

AVERAGEX

BETA.DIST

BETA.INV

CHISQ.INV

CHISQ.INV.RT

CONFIDENCE.NORM

CONFIDENCE.T

COUNT

COUNTA

COUNTAX

COUNTBLANK

COUNTROWS

COUNTX

CROSSJOIN

DATATABLE function

DISTINCTCOUNT

EXPON.DIST

GENERATE

GENERATEALL

GEOMEAN

GEOMEANX

MAX

MAXA

MAXX

MEDIAN

MEDIANX

MIN

MINA

MINX

NORM.DIST

NORM.INV

NORM.S.DIST

NORM.S.INV (DAX)

PERCENTILE.EXC

PERCENTILE.INC

PERCENTILEX.EXC

PERCENTILEX.INC

POISSON.DIST

RANK.EQ

RANKX

ROW

SAMPLE

SELECTCOLUMNS

SIN

SINH

STDEV.P

STDEV.S

STDEVX.P

STDEVX.S

SQRTPI

SUMMARIZE

T.DIST

T.DIST.2T

T.DIST.RT

T.INV

T.INV.2t

TAN

TANH

TOPN

VAR.P

VAR.S

VARX.P

VARX.S

XIRR

XNPV