MAX(): MAX( Profit ) : Latest/largest value

COUNT(): COUNT( Order ID ) : Number of non blank rows

COUNTA(): COUNTA( Comments ) : Count including text/blank

DISTINCTCOUNT(): DISTINCTCOUNT( Customer ID ) : Count unique values

COUNTROWS(): COUNTROWS( Orders ) : Rows in a table expression

COUNTX(): COUNTX( Products, Products[OnHand] ) : Iterator counting per row expression

DIVIDE(): DIVIDE( Sales, Orders ) : Safe division handling zero

PRODUCT(): PRODUCT( Quantity ) : Multiply values together

PERCENTILE.EXC(): PERCENTILE.EXC( Sales,0.9 ) : Exclusive percentile value

MEDIAN(): MEDIAN( Profit ) : Median value within context

STDEV.P(): STDEV.P( Sales ) : Population standard deviation

VAR.S(): VAR.S( Profit ) : Sample variance