Chapter 9. PowerPivot DAX Patterns
In this chapter, we show you many common DAX calculations using techniques that can be easily applied to your own Microsoft SQL Server PowerPivot for Excel models. As you will see, DAX calculations might have significant differences from one another, depending on the underlying data model. For this reason, you should be sure that you understand the data modeling concepts presented in Chapter 4, of this book.
Calculating Ratio and Percentage
In Chapter 8, you saw some of the Excel features that allow you to show a value as a percentage of a total. However, you might need to make this calculation in a measure or in a calculated column, for example, because you need that number as part of another calculation.