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 ﬁlters at column granularity level, and how to transform a row context into a ﬁlter 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 ﬁlters, 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 oﬀ all memberships with code DEC12TENUSD at checkout, or use code DEC12TWENTYPCT for a rarely-oﬀered 20% discount of the cost of an individual, annual membership, worth $58! Hurry, those oﬀers are only valid in December 2012.