Introduces a statement that defines sort order of query results returned by an EVALUATE statement in a DAX query. Syntax DAX [ORDER BY {<expression> [ {ASC | DESC}]} _…]]

The function groups a selected set of rows into a set of summary rows by the values of one or more groupBy_columnName columns. One row is returned for each group. GROUPBY is primarily used to perform aggregations over intermediate results from DAX table expressions.

Returns a summary table over a set of groups. Syntax DAX SUMMARIZECOLUMNS(<groupBy_columnName> _{< groupBy_columnName >]…, [<filterTable>]… [, <name>, <expression>]…)}

Defines the expressions that determine the sort order within each of a window function’s partitions. Syntax DAX ORDERBY ([<orderBy_expression> _{<order> [, <orderBy_expression> [, <order>]] …]])}