What are the Functions available in DAX - Statistical Functions? Explain?

May 20

Statistical Functions (DAX)

Hi there,

In this post, we will discuss about one of the types of DAX Functions. These functions basically supports the needs of Business Intelligence Analysis. These functions will help to manipulate data using time periods.

TYPES OF DAX:

DATE AND TIME FUNCTIONS
FILTER FUNCTIONS
INFORMATION FUNCTIONS
LOGICAL FUNCTIONS
MATHEMATICAL AND TRIGNOMETRIC FUNCTIONS
STATISTICAL FUNCTIONS
TEXT FUNCTIONS
TIME INTELLIGENCE FUNCTIONS

STATISTICAL FUNCTIONS:

...

ADDCOLUMNS: This function adds calculated columns to the given table of data.
AVERAGE: This function calculates the average of a particular column.
AVERAGEA: This function returns the average of a specified column including numeric and non-numeric.
AVERAGEX: This function calculates the average of a set of expressions evaluated over a table.
COUNT: This function counts the numbers in a column.
COUNTA: This function counts the number of non-blank cells in a column. Non-Blank includes text, dates and logical values,.
COUNTAX: This function counts non-blank results when evaluating the result of an expression over a table.
COUNTBLANK: This function counts the number of blank cells in a column.
COUNTROWS: This function returns the number of rows in the specified table.
COUNTX: This function counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table.
CROSSJOIN: This function returns a table that contains the Cartesian product of all rows from all tables in the arguments.
DISTINCTCOUNT: This function counts the number of unique cells in a column.
GENERATE: This function returns a table with the Cartesian product between each row in table 1 and the table that results from evaluating table2 in the context of the current row from table1.
GENERATEALL: This function returns a table with Cartesian product between each row in table1 and the table that results from evaluating table 2 in the context of the current row from table 1.
MAX: This function returns the largest numeric value in a column.
MAXA: This function retunrs the largest value in a column, considering logical values and blanks.
MAXX: This function evaluates an expression for each row of a table and returns the largest numeric value.
MIN: This function returns a smallest value in a column, excludes logical values and text.
MINA: This function returns a smallest value in a column including any logical values and numbers represented as text.
MINX: This function returns the smallest numeric value that results from evaluating an expression for each row of a table.
RANK.EQ: This function returns the position of a value based on selection.
RANKX: This function returns the ranking of a number in a list of numbers for each row in the table argument.
ROW: This function returns a table with a single row containing values that result from the expressions given to each column.
STDEV.S: This function returns the standard deviation of a sample population.
STDEV.P: This function returns a standard deviation of an entire population.
STDEVX.S: This function returns the standard deviation of a sample population.
STDEVX.P: This function returns a standard deviation of an entire population.
SUMMARIZE: This function returns a summary table for the requested totals over a set of groups.
TOPN: This function returns the top N rows of the specified table.
VAR.S: This function returns the variance of a sample population.
VAR.P: This function returns the variance of the entire population.
VARX.S: This function returns the variance of a sample population.
VARX.P: This function returns the variance of the entire population.
SAMPLE: This function returns a sample of N rows from the specified table.