MAX
The MAX function returns the largest value of a column or of two scalar expressions considering numbers, dates and texts.
SUM
The SUM function sums the numbers contained in a column.
AVERAGE
The AVERAGE function returns the arithmetic mean of the values in a column.
COUNT
The COUNT function counts the number of cells in a column that contain numbers, dates, or text strings.
COUNTROWS
The COUNTROWS function counts the number of rows in a table.
DISTINCTCOUNT
The DISTINCTCOUNT function counts the number of distinct values in a column.
ALLEXCEPT
The ALLEXCEPT function removes all context filters applied to the specified table except those that reference the columns included as arguments.
ALLSELECTED
The ALLSELECTED function removes filters coming from the rows and columns of the visual object where the measure is located, leaving the other context or explicit filters in place.
PRODUCT
The PRODUCT function returns the product of the values contained in a column.
FILTER
The FILTER function returns a table that represents a subset of another table.
