57.1 DAX Formulas for PowerPivot – Chapter 13

Chapter 13 starts off by finishing the second example started at the end of chapter 12 and, coincidentally, introducing the FILTERI() function. Guidance is given for when to use FILTER() and why it’s cool. Along the way, some tips for debugging measure calculations and instructions for how to do copy-and-paste measure development are presented.

The “show me products above a selected list price” is enhanced to show how to do upper and lower bound thresholds. To make it interesting, the ranges in the example are overlapping.

I feel compelled to point out a couple of errors in the chapter:

  • When creating the disconnected table for the second example, a column is added to the table to facilitate sorting. The name of the table, “MidPt,” implies that the data value will be the midpoint of the range for each row. But the formula doesn’t calculate the mid point – it’s ([MaxPrice] – [MinPrice]) / 2 when it should be [MinPrice] + (([MaxPrice] – [MinPrice]) / 2).
  • At the top of page 109, the modified version of the measure for the Sales table is not shown (as expected). Instead, it’s just a copy of the original measure as shown on the previous page.

Hey Rob, if you’re looking for someone to review your next book before publishing, give me a call 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s