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.
Function | Description |
---|---|
APPROXIMATEDISTINCTCOUNT | It is used to return the approximate number of rows that contain distinct values in a column. |
AVERAGE | It is used to return the average (arithmetic mean) of all the numbers in a column. |
AVERAGEA | It is used to return the average (arithmetic mean) of the values in a column. |
AVERAGEX | It is used to calculate the average (arithmetic mean) of a set of expressions evaluated over a table. |
BETA.DIST | It is used to return the beta distribution. |
BETA.INV | It is used to return the inverse of the beta cumulative probability density function (BETA.DIST). |
CHISQ.DIST | It is used to return the chi-squared distribution. |
CHISQ.DIST.RT | It is used to return the right-tailed probability of the chi-squared distribution. |
CHISQ.INV | It is used to return the inverse of the left-tailed probability of the chi-squared distribution. |
CHISQ.INV.RT | It is used to return the inverse of the right-tailed probability of the chi-squared distribution. |
CONFIDENCE.NORM | The confidence interval is a range of values. |
CONFIDENCE.T | It is used to return the confidence interval for a population mean, using a Student’s t distribution. |
COT | It is used to return the cotangent of an angle specified in radians. |
COTH | It is used to return the hyperbolic cotangent of a hyperbolic angle. |
COUNT | It is used to count the number of cells in a column that contain numbers. |
COUNTA | It is used to count the number of cells in a column that are not empty. |
COUNTAX | It is used to count nonblank results when evaluating the result of an expression over a table. |
COUNTBLANK | It is used to count the number of blank cells in a column. |
COUNTROWS | It is used to count the number of rows in the specified table, or in a table defined by an expression. |
COUNTX | It 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. |
DATATABLE | It provides a mechanism for declaring an inline set of data values. |
DISTINCTCOUNT | It is used to count the number of distinct values in a column. |
DISTINCTCOUNTNOBLANK | It is used to count the number of distinct values in a column. |
EXPON.DIST | It is used to return the exponential distribution. |
GEOMEAN | It is used to return the geometric mean of the numbers in a column. |
GEOMEANX | It is used to return the geometric mean of an expression evaluated for each row in a table. |
MAX | It is used to return the largest numeric value in a column, or between two scalar expressions. |
MAXA | It is used to return the largest value in a column. |
MAXX | It is used to evaluate an expression for each row of a table and returns the largest numeric value. |
MEDIAN | It is used to return the median of numbers in a column. |
MEDIANX | It is used to return the median number of an expression evaluated for each row in a table. |
MIN | It is used to return the smallest numeric value in a column, or between two scalar expressions. |
MINA | It is used to return the smallest value in a column, including any logical values and numbers represented as text. |
MINX | It is used to return the smallest numeric value that results from evaluating an expression for each row of a table. |
NORM.DIST | It is used to return the normal distribution for the specified mean and standard deviation. |
NORM.INV | The inverse of the normal cumulative distribution for the specified mean and standard deviation. |
NORM.S.DIST | It is used to return the standard normal distribution (has a mean of zero and a standard deviation of one). |
NORM.S.INV | It is used to return the inverse of the standard normal cumulative distribution. |
PERCENTILE.EXC | It is used to return the k-th percentile of values in a range, where k is in the range 0..1, exclusive. |
PERCENTILE.INC | It is used to return the k-th percentile of values in a range, where k is in the range 0..1, inclusive. |
PERCENTILEX.EXC | It is used to return the percentile number of an expression evaluated for each row in a table. |
PERCENTILEX.INC | It is used to return the percentile number of an expression evaluated for each row in a table. |
POISSON.DIST | It is used to return the Poisson distribution. |
RANK.EQ | It is used to return the ranking of a number in a list of numbers. |
RANKX | It is used to return the ranking of a number in a list of numbers for each row in the table argument. |
SAMPLE | It is used to return a sample of N rows from the specified table. |
SIN | It is used to return the sine of the given angle. |
SINH | It is used to return the hyperbolic sine of a number. |
STDEV.P | It is used to return the standard deviation of the entire population. |
STDEV.S | It is used to return the standard deviation of a sample population. |
STDEVX.P | It is used to return the standard deviation of the entire population. |
STDEVX.S | It is used to return the standard deviation of a sample population. |
SQRTPI | It is used to return the square root of (number * pi). |
T.DIST | It is used to return the Student’s left-tailed t-distribution. |
T.DIST.2T | It is used to return the two-tailed Student’s t-distribution. |
T.DIST.RT | It is used to return the right-tailed Student’s t-distribution. |
T.INV | It is used to return the left-tailed inverse of the Student’s t-distribution. |
T.INV.2t | It is used to return the two-tailed inverse of the Student’s t-distribution. |
TAN | It is used to return the tangent of the given angle. |
TANH | It is used to return the hyperbolic tangent of a number. |
VAR.P | It is used to return the variance of the entire population. |
VAR.S | It is used to return the variance of a sample population. |
VARX.P | It is used to return the variance of the entire population. |
VARX.S | It is used to return the variance of a sample population. |
Learn more about: Statistical Function DAX
Prepare for Assured Success
Want to qualify DA-100: Analyzing Data with Microsoft Power BI exam? Learn MoreAre you preparing for DA-100: Analyzing Data with Microsoft Power BI exam?Take a Quiz