FILTER() – When, Why, & How to Use It

June 14, 2012

 
A recent comment/question alerted me to the fact that I’ve never devoted a post just to this very useful (and often misunderstood) function.  Time to correct that.

The #1 Reason to Use FILTER – When CALCULATE Breaks Down

A function 'CALCULATE' has been used in a Boolean expression that is used as a table filter expression. This is not allowed.

Does this Mysterious Error Look Familiar?

 

Read the rest of this entry »