Dax Function: Statistical Functions
Category: Statistical functions
Statistical functions in Power BI are used to perform statistical calculations on datasets, including measures of central tendency, dispersion, ranking, and counting. These functions help users analyze and summarize data effectively within Power BI reports and dashboards.
Purpose
The primary purpose of statistical functions is to enable data professionals to derive meaningful insights from datasets. These functions can compute averages, medians, percentiles, ranks, standard deviations, and more. Statistical functions are essential for identifying patterns, trends, and distributions in data.
| Function | Description |
|---|---|
| BETA.DIST | Calculates the beta distribution. |
| BETA.INV | Computes the inverse of the beta cumulative probability density function (BETA.DIST). |
| CHISQ.DIST | Produces the chi-squared distribution. |
| CHISQ.DIST.RT | Calculates the right-tailed probability of the chi-squared distribution. |
| CHISQ.INV | Finds the inverse of the left-tailed probability for the chi-squared distribution. |
| CHISQ.INV.RT | Finds the inverse of the right-tailed probability for the chi-squared distribution. |
| COMBIN | Determines the number of combinations for a specified set of items. |
| COMBINA | Computes the number of combinations (with repetitions) for a given number of items. |
| CONFIDENCE.NORM | Calculates the confidence interval range for a normal distribution. |
| CONFIDENCE.T | Provides the confidence interval for a population mean using the Student’s t-distribution. |
| EXPON.DIST | Computes the exponential distribution. |
| GEOMEAN | Calculates the geometric mean of values in a column. |
| GEOMEANX | Returns the geometric mean of an expression evaluated for each row in a table. |
| LINEST | Uses the Least Squares method to determine the best-fit straight line for given data points. |
| LINESTX | Determines the best-fit straight line using Least Squares for data derived from row-based expressions. |
| MEDIAN | Computes the median value in a column. |
| MEDIANX | Evaluates the median value of an expression for each row in a table. |
| NORM.DIST | Returns the normal distribution based on a given mean and standard deviation. |
| NORM.INV | Computes the inverse of the normal cumulative distribution for a specified mean and standard deviation. |
| NORM.S.DIST | Provides the standard normal distribution with a mean of zero and a standard deviation of one. |
| NORM.S.INV | Calculates the inverse of the standard normal cumulative distribution. |
| PERCENTILE.EXC | Returns the k-th percentile of a range of values, with k being in the range (0,1) exclusive. |
| PERCENTILE.INC | Produces the k-th percentile of values in a range, where k is in the range [0,1], inclusive. |
| PERCENTILEX.EXC | Evaluates the k-th percentile for an expression for each row in a table, with k in (0,1). |
| PERCENTILEX.INC | Evaluates the k-th percentile for an expression for each row in a table, where k is within [0,1]. |
| PERMUT | Calculates the number of permutations of objects that can be selected from a given set. |
| POISSON.DIST | Computes the Poisson distribution. |
| RANK.EQ | Returns the rank of a value in a list of numbers. |
| RANKX | Computes the rank of a value for each row in a table based on an expression. |
| SAMPLE | Extracts a sample of N rows from the specified table. |
| SAMPLECARTESIANPOINTSBYCOVER | Extracts sample Cartesian points from the specified table based on cover criteria. |
| STDEV.P | Determines the standard deviation of an entire population. |
| STDEV.S | Calculates the standard deviation for a sample. |
| STDEVX.P | Returns the standard deviation for the entire population from evaluated expressions. |
| STDEVX.S | Computes the standard deviation of a sample population from evaluated expressions. |
| T.DIST | Produces the Student’s left-tailed t-distribution. |
| T.DIST.2T | Calculates the two-tailed Student’s t-distribution. |
| T.DIST.RT | Returns the right-tailed Student’s t-distribution. |
| T.INV | Determines the left-tailed inverse of the Student’s t-distribution. |
| T.INV.2T | Finds the two-tailed inverse of the Student’s t-distribution. |
| VAR.P | Computes the variance for an entire population. |
| VAR.S | Returns the variance for a sample population. |
| VARX.P | Calculates the variance for the entire population based on evaluated expressions. |
| VARX.S | Determines the variance of a sample population based on evaluated expressions. |
Maximize the potential of Power BI and enhance your data insights with our expert consulting services. Whether you’re looking for assistance with advanced DAX functions, help designing interactive dashboards, or support in optimizing your data models for better performance, our skilled Power BI consultants are ready to provide tailored solutions for your business. Visit our Power BI consultancy page to learn more about how we can empower your organization to make more informed, data-driven decisions.
Statistical functions in Power BI perform calculations like averages, medians, ranks, and standard deviations to summarize and analyze datasets.
Yes, many statistical functions can be used in calculated columns, measures, and calculated tables.
The MEDIAN function returns the middle value in a dataset, while AVERAGE computes the arithmetic mean of all values.
Statistical functions can impact performance in large datasets, especially if used extensively in measures or visuals. Optimize your DAX queries to improve performance.
Refer to the official Power BI documentation for detailed examples and explanations.