DAX Function Reference - Visual Intelligence - page 379

FuNCTIoN DESCrIPTIoN

COUNTX(< table >, < expression >) Counts the number of rows that con-

tain a number or an expression that
evaluates to a number, when evaluat-
ing an expression over a table.

DISTINCTCOUNT(< column >) Counts the number of different cells

in a column of numbers.

MAX(< column >) Returns the largest numeric value in

a column.

MAXA(< column >) Returns the largest value in a col-

umn. Logical values and blanks are
counted.

MAXX(< table >, < expression >) Evaluates an expression for each row

of a table and returns the largest
numeric value.

MIN(< column >) Returns the smallest numeric value

in a column. Ignores logical values
and text.

MINA(< column >) Returns the smallest value in a col-

umn, including any logical values and
numbers represented as text.

MINX(< table >, < expression >) Returns the smallest numeric value

that results from evaluating an
expression for each row of a table.

RANK.EQ(< value >, < column >,
< order >)

Returns the ranking of a number in a
list of numbers.

RANKX(< table >, < expression >,
< value >, < order >, < ties >)

Returns the ranking of a number in
a list of numbers for each row in the
table argument.

SUM(< column >) Adds all the numbers in a column.

SUMX(< table >, < expression >) Returns the sum of an expression

evaluated for each row in a table.

TOPN(< n_value >, < table >,
< orderBy_expression >, < order >)

Returns the top N rows of the speci-
fied table.

MATH AND TrIG FuNCTIoNS

DAX does not provide any of the trigonometry functions such as SIN and
COS—you will need to use SIN tables to do these types of calculations. The
functions DAX does provide are listed in Table B-11.