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 🙂