Introducing table functionsIntroducing the EVALUATE syntaxUnderstanding FILTERUnderstanding ALL and ALLEXCEPTUnderstanding VALUES, DISTINCT, and the blank rowUnderstanding SELECTCOLUMNS and ADDCOLUMNSUnderstanding SUMMARIZEIntroducing SUMMARIZECOLUMNSComputing the best store by productUsing tables as scalar valuesIntroducing ALLSELECTEDConclusions