Statistical Functions DAX

  1. Home
  2. Statistical Functions DAX

Data Analysis Expressions (DAX) facilitates with many functions used for creating aggregations including sums, counts, and averages. However, these functions are more like the aggregation functions used by Microsoft Excel. We shall now list the statistical functions used for aggregation provided in DAX.

FunctionDescription
APPROXIMATEDISTINCTCOUNTIt is used to return the approximate number of rows that contain distinct values in a column.
AVERAGEIt is used to return the average (arithmetic mean) of all the numbers in a column.
AVERAGEAIt is used to return the average (arithmetic mean) of the values in a column.
AVERAGEXIt is used to calculate the average (arithmetic mean) of a set of expressions evaluated over a table.
BETA.DISTIt is used to return the beta distribution.
BETA.INVIt is used to return the inverse of the beta cumulative probability density function (BETA.DIST).
CHISQ.DISTIt is used to return the chi-squared distribution.
CHISQ.DIST.RTIt is used to return the right-tailed probability of the chi-squared distribution.
CHISQ.INVIt is used to return the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ.INV.RTIt is used to return the inverse of the right-tailed probability of the chi-squared distribution.
CONFIDENCE.NORMThe confidence interval is a range of values.
CONFIDENCE.TIt is used to return the confidence interval for a population mean, using a Student’s t distribution.
COTIt is used to return the cotangent of an angle specified in radians.
COTHIt is used to return the hyperbolic cotangent of a hyperbolic angle.
COUNTIt is used to count the number of cells in a column that contain numbers.
COUNTAIt is used to count the number of cells in a column that are not empty.
COUNTAXIt is used to count nonblank results when evaluating the result of an expression over a table.
COUNTBLANKIt is used to count the number of blank cells in a column.
COUNTROWSIt is used to count the number of rows in the specified table, or in a table defined by an expression.
COUNTXIt is used to count the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table.
DATATABLEIt provides a mechanism for declaring an inline set of data values.
DISTINCTCOUNTIt is used to count the number of distinct values in a column.
DISTINCTCOUNTNOBLANKIt is used to count the number of distinct values in a column.
EXPON.DISTIt is used to return the exponential distribution.
GEOMEANIt is used to return the geometric mean of the numbers in a column.
GEOMEANXIt is used to return the geometric mean of an expression evaluated for each row in a table.
MAXIt is used to return the largest numeric value in a column, or between two scalar expressions.
MAXAIt is used to return the largest value in a column.
MAXXIt is used to evaluate an expression for each row of a table and returns the largest numeric value.
MEDIANIt is used to return the median of numbers in a column.
MEDIANXIt is used to return the median number of an expression evaluated for each row in a table.
MINIt is used to return the smallest numeric value in a column, or between two scalar expressions.
MINAIt is used to return the smallest value in a column, including any logical values and numbers represented as text.
MINXIt is used to return the smallest numeric value that results from evaluating an expression for each row of a table.
NORM.DISTIt is used to return the normal distribution for the specified mean and standard deviation.
NORM.INVThe inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM.S.DISTIt is used to return the standard normal distribution (has a mean of zero and a standard deviation of one).
NORM.S.INVIt is used to return the inverse of the standard normal cumulative distribution.
PERCENTILE.EXCIt is used to return the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INCIt is used to return the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
PERCENTILEX.EXCIt is used to return the percentile number of an expression evaluated for each row in a table.
PERCENTILEX.INCIt is used to return the percentile number of an expression evaluated for each row in a table.
POISSON.DISTIt is used to return the Poisson distribution.
RANK.EQIt is used to return the ranking of a number in a list of numbers.
RANKXIt is used to return the ranking of a number in a list of numbers for each row in the table argument.
SAMPLEIt is used to return a sample of N rows from the specified table.
SINIt is used to return the sine of the given angle.
SINHIt is used to return the hyperbolic sine of a number.
STDEV.PIt is used to return the standard deviation of the entire population.
STDEV.SIt is used to return the standard deviation of a sample population.
STDEVX.PIt is used to return the standard deviation of the entire population.
STDEVX.SIt is used to return the standard deviation of a sample population.
SQRTPIIt is used to return the square root of (number * pi).
T.DISTIt is used to return the Student’s left-tailed t-distribution.
T.DIST.2TIt is used to return the two-tailed Student’s t-distribution.
T.DIST.RTIt is used to return the right-tailed Student’s t-distribution.
T.INVIt is used to return the left-tailed inverse of the Student’s t-distribution.
T.INV.2tIt is used to return the two-tailed inverse of the Student’s t-distribution.
TANIt is used to return the tangent of the given angle.
TANHIt is used to return the hyperbolic tangent of a number.
VAR.PIt is used to return the variance of the entire population.
VAR.SIt is used to return the variance of a sample population.
VARX.PIt is used to return the variance of the entire population.
VARX.SIt is used to return the variance of a sample population.

Learn more about: Statistical Function DAX

Microsoft Exam DA-100 Free Practice Test
Menu