PowerPivot: DAX: 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.

Read more about the following statistical functions:

• AVERAGE
• AVERAGEA
• AVERAGEX
• COUNT
• COUNTA
• COUNTAX
• COUNTBLANK
• COUNTROWS
• COUNTX
• MAX
• MAXA
• MAXX
• MIN
• MINA
• MINX

Original article (before wiki edits) was written by Jeannine Takaki and JuanPablo Jofre and formatted by Mary Browning, Microsoft SQL Server Technical Writers.