10. Using DAX for Aggregate Functions

In This Chapter

DAX Measures Are Calculated Fields for the Values Area of a Pivot Table 218

Generate a Count Distinct 220

Using Other DAX Functions That Respect the Filters 226

Denominators Frequently Need to Ignore the Filters 228

Using the FILTER Function 234

The Double Negative of AllExcept 237

Other DAX Functions 238

You really have to read this chapter. My plan is to show you some really simple examples of stuff that would be insanely hard in a regular pivot table but would be really easy thanks to something called a DAX measure.

But first, I have to tell you that I hate sentences where I don’t understand a majority of the words. A long time ago, my fiancé was in nursing school and I knew how to ...

Get PowerPivot for the Data Analyst: Microsoft 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.

Start your free trial