DAX function reference

  • COUNTROWS(<table expression>) → int

  • FILTER(<table expression>, <criterion>) → table expression

  • DISTINCT(<column expression>) → column expression

  • BLANK() → null

  • ISBLANK(<value expression>) → bool

  • SUM(<column expression>) → number

    Returns the sum of all values in <column expression>.

  • SUMX(<table expression>, <numeric expression>) → number

    Returns the sum of <numeric expression> evaluated for each row in <table expression>.

  • PRODUCT(<column expression>) → number

    Returns the product of all values in <column expression>.

  • PRODUCTX(<table expression>, <numeric expression>) → number

    Returns the product of <numeric expression> evaluated for each row in <table expression>.

  • AVERAGE(<column expression>) → number

  • AVERAGEX(<table expression>, <numeric expression>) → number

    Returns the mean <numeric expression> evaluated for each row in <table expression>.

  • COUNT(<column expression>) → number

    Returns the number of rows in <column expression> in which the expression is non-empty (i.e. ISEMPTY(<column expression>) = false).

  • COUNTX(<table expression>, <expression>) → number

    Returns the number of rows in <table expression> in which <expression> is non-empty.

  • MAX(<column expression>) → number

    Returns the largest numeric value in <column expression>.

  • MAXX(<table expression>, <numeric expression>) → number

    Returns the largest <numeric expression> evaluated for each row in <table expression>.

  • MAXA(<column expression>) → number

    Returns the largest value in <column expression>, including text and booleans.

  • CONCATENATE(<text expression>, <text expression>) → text

    Concatenates two <text expression> values together.

  • CONCATENATEX(<table expression>, <text expression>) → text

    Concatenates the result of <text expression> evaluated for each row in <table expression>.