Chapter 6Fundamental Functions: Filter, Logical, and Miscellaneous Functions

This is a wide-ranging chapter on some of the fundamental DAX functions. It includes syntax and examples for all of the Filter functions and all of the Logical functions. In addition, it discusses some other functions—for example, those that are often referred to as Information or IS() functions. An example is ISBLANK(). There is also one Text function, BLANK(), which has been added here because of its close relationship to ISBLANK(). The Filter functions, in particular, are extremely powerful. Among other things, they allow you to override the filter context that a user chooses in a pivot table. They help to display classic BI values such as “percentage of parent” or ...

Get Practical PowerPivot & DAX Formulas for Excel 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.