The Incredible "Iffer-Blanker-Filter" Measure

Omitting/Filtering Out Pivot Rows Based on an IF()

I've had this on my list to share for a long time, but David Churchward's recent guest post bubbled it to the top. At one point in that post, he had a nested IF measure that basically looked like this: