VAR : VAR _sales = SUM( Sales ) : Define reusable variable

RETURN : VAR a=1 RETURN a+1 : Return result of expression

SUMMARIZE() : SUMMARIZE( Orders, Orders[Region], "Sales", SUM(Orders[Sales]) ) : Group table and
aggregate

GROUPBY() : GROUPBY( Orders, Orders[Region], "Avg", AVERAGEX(CURRENTGROUP(),Orders[Sales]) ) :
Advanced group by with CURRENTGROUP

ALLNOBLANKROW() : ALLNOBLANKROW( Customer ) : Remove blank row added for model integrity

TREATAS() : TREATAS( VALUES(Region[Name]), Sales[Region] ) : Apply custom filter table onto column

LOOKUPVALUE() : LOOKUPVALUE( Rates[Rate], Rates[Key], Sales[Key] ) : Search table for
corresponding value

PATH() : PATH( Parent[ID], Parent[ParentID] ) : Hierarchy path text

PATHCONTAINS() : PATHCONTAINS( PathCol, SelectedID ) : Check if id in path

PATHITEM() : PATHITEM( PathCol, 2, INTEGER ) : Return item from hierarchy path