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.
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)
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)
Data Analysis Expressions (DAX) Overview
DAX Syntax Specification for PowerPivot
Date and Time Functions (DAX)
Statistical Functions (DAX)
Logical Functions (DAX)
Filter Functions (DAX)
Math and Trig Functions (DAX)