DAX Average Function

DAX Average Functions

• AVERAGE() function computes the average of the values contained in the provided column as input.
• A row is counted among the number of rows used as the divisor when a cell carries a value of 0, which is added to the sum of all the numbers.
• The row is not tallied when a cell is blank.

DAX AverageA Function

• AVERAGEA() function gives the average (arithmetic mean) of the values in a column.
• AVERAGEA function averages the values in a column and also manages non-numeric data types:
  • Values that are TRUE, count as 1.
  • Empty text (“”) counts as 0 (zero).
  • Non-numeric text values have a count of 0 (zero).
  • FALSE values are counted as 0 values (zero).

DAX AverageX Function

• AVERAGEX() function calculates the average (arithmetic mean) of a set of expressions evaluated over a table.

DAX Count Functions

• COUNT() function only accepts a column as an argument and counts the following types of values:
  • Numbers
  • Dates
  • Strings

DAX CountA Function

• COUNTA() function determines how many rows in the chosen column have non-blank values.
• The function returns a blank if it cannot locate any rows to count.

DAX CountX Function

• COUNTX() function counts the number of rows that contain a number or an expression that evaluates to a number.
• It can be used to calculate the counts of rows based on certain expressions within FILTER.
• Requires two arguments: a table or an expression returning a table, and the column or expression that COUNTX searches for.

DAX CountAX Function

• COUNTAX() function counts non-blank results when evaluating the result of an expression over a table.
• It functions just like the COUNTA function but is used to loop across table rows and count the rows where the supplied expressions return a result that is not blank.

DAX CountBlank Function

• COUNTBLANK() function counts only blank cells in a column.
• Cells with the value zero (0) are not counted because zero is a valid numeric value and not a blank cell.

DAX CountRows Function

• COUNTROWS() function determines how many rows there are in the supplied table or a table that has been defined using an expression.

DAX DistinctCount Function

• DISTINCTCOUNT() function determines how many unique values there are in a column.
• It returns a BLANK if there are no rows to count; otherwise, it gives the number of distinct values.
• DISTINCTCOUNTNOBLANK() function also exists.

DAX MAX and MIN Functions

• MAX() function returns the largest numeric value in a column or between two scalar expressions.

• MAXA() function returns the largest value in a column, including any logical values and numbers represented as text.

• MAXX() function evaluates an expression for each row of a table and returns the largest numeric value.

• MIN() function returns the smallest numeric value in a column or between two scalar expressions.

• MINA() function returns the smallest value in a column, including any logical values and numbers represented as text.

• MINX() function returns the smallest numeric value that results from evaluating an expression for each row of a table.

DAX Product Functions

• PRODUCT() function returns the product of the numbers in a column.
• PRODUCTX() function returns the product of an expression evaluated for each row in a table.

DAX Sum Functions

• SUM() function adds all the numbers in a column.
• SUMX() function returns the sum of an expression evaluated for each row in a table.