SUMX(): SUMX( Orders, Orders[Quantity] * Orders[UnitPrice] ) : Row-wise calculation then aggregation

AVERAGEX(): AVERAGEX( Customers, Customers[Sales] ) : Iterator for average

MINX(): MINX( Products, Products[Margin] ) : Iterator for min

MAXX(): MAXX( Products, Products[Margin] ) : Iterator for max

COUNTAX(): COUNTAX( Products, Products[Name] ) : Iterator counting non-blank strings

RANKX(): RANKX( ALL(Customer), CALCULATE( SUM(Sales) ) ) : Rank measure within set

TOPN(): TOPN( 5, Customers, [Total Sales] ) : Return top N rows by expression

BOTTOMN(): BOTTOMN( 3, Products, [Profit] ) : Bottom N rows

ADDCOLUMNS(): ADDCOLUMNS( Products, "Profit", Products[Sales]-Products[Cost] ) : Add calculated column to table expression

SELECTCOLUMNS(): SELECTCOLUMNS( Sales, "PID", Sales[ProductID], "Amount", Sales[Sales] ) : Return custom column set

UNION(): UNION( TableA, TableB ) : Combine tables vertically

INTERSECT(): INTERSECT( CustomersUSA, CustomersEU ) : Common rows between tables

EXCEPT(): EXCEPT( MasterList, Completed ) : Rows in first not in second

CROSSJOIN(): CROSSJOIN( Products, Colors ) : Cartesian product of tables

GENERATE(): GENERATE( Customers, Orders ) : Combine row and related table into single table