Chapter 9. DAX Syntax and Calculations

In this chapter, we will cover the following recipes:

• Understanding DAX formulas

• Using the AutoSum measure in Visual Studio

• Creating calculated measures

• Creating calculated columns

• Using the IF function

• Using the AND function

• Using the SWITCH function

• Using the CONCATENATE function

• Using the LEFT function

• Using the RELATED function

• Using the RELATEDTABLE function

• Using EVALUATE in DAX queries

• Filtering based on a value

• Filtering a related table

• Using ALL to remove filters

• Using ALL to calculate a percentage

• Using the SUMMARIZE function

• Adding columns to the SUMMARIZE function

• Using ROLLUP with the SUMMARIZE function