We have just published our newest video tutorial: DAX: The CALCULATE Function. Marco Russo, respected author and mentor from sqlbi.com, explains when to use this function and introduces its syntax, before showing you in-depth examples of how to manipulate filters at column granularity level, and how to transform a row context into a filter context, in 5 extensive, high-resolution demos. Learning these concepts will enable you to write advanced, real-world calculations in Data Analysis Expressions, such as percentage of a total, that work properly with other filters, slicers, and so on. This 47-minute tutorial is part of our video series on DAX, and you should study it, ideally, after you have learned about DAX Evaluation Context.

Please note, this module is available to our Full Access Members only. Membership is inexpensive, and you can take advantage of two holiday period promotions available at the moment to join, or to extend your existing membership: get $10 off all memberships with code DEC12TENUSD at checkout, or use code DEC12TWENTYPCT for a rarely-offered 20% discount of the cost of an individual, annual membership, worth $58! Hurry, those offers are only valid in December 2012.