Measure Calculation and the CALCULATE Function

Excerpts from PowerPivotPro School

Since it’s been the primary focus of my time lately, for today’s post I thought I’d share two excerpts from the upcoming PowerPivotPro School.

Intro to CALCULATE()

The first one is the complete and uncut introduction to the CALCULATE function:

That’s only the intro of course.  There is a lot more on CALCULATE obviously.  Even the “basics” consume quite a bit more time in the course, but I thought you’d like to see this first part.  I hope it helps some of you even if you don’t choose to join the course.

How Measures Are Calculated – Three Minute “Montage”

Chronologically, this clip occurs before CALCULATE in the course.  This is from the module called “Warmup and Fundamentals.”  It’s 3 minutes of “highlights” spliced together from a longer, 20 minute section:

Whereas the first video above is at “normal speed,” this one moves faster simply because I’ve edited out a lot of the more complete description and background.  The actual course moves more deliberately.

Sign Ups Open Until August 15th

If you’re interested in joining us for the course, signups remain open until August 15th.  Hope to see you there:


I’m getting a lot of questions about how the course is structured and delivered.  I’m compiling a FAQ and should post that tomorrow.

11 Responses to Measure Calculation and the CALCULATE Function

  1. Are the videos from the Advanced class?

  2. The Intro to Calculate() is well presented and informative. Not sure about the voice, though. I started to feel sleepy at about the 15 minute mark. One of us would need a double-shot of espresso for me to be able to stay lively for a 30-minute session ;-)

    Uh-oh, you know what popped into my head? Making the Adv. PP videos the feature presentation at EUG meetings! Only that would be naughty. Unless there was a special group license for just the videos… ehem.

    • powerpivotpro says:

      Hey, the fundamentals aren’t the sexiest topic. I thought I did pretty well making them interesting, all told :)

      Anyway, I think the fun factor picks up steadily, once the fundamentals are established.

  3. Amy J says:

    Thank goodness, you were able to incorporate your drawings into the video. What is a power pivot training without massive amounts of scribbling on a white board??

  4. Anne says:

    Good explanation of that very issue (which I had come across before). Of course what I really want to learn now is how to make calculate more dynamic, how to use the filters aspect without having to hard wire something into it e.g. bikes as you have used.

    • powerpivotpro says:

      Yes, and naturally, that is covered. Many different ways actually, since the CALCULATE function is the basis for basically all such magic in all its flavors :)

  5. Just finished watching. Nice job using animations, and the pace is good. I am signed up for class and look forward to it.

  6. Ryan Wilson says:

    I signed up, but I was wondering are all videos for the class going to be released on August 19? Or a couple of videos each week?

    • powerpivotpro says:

      It’s scheduled for about four hours of training each week. We will sustain that for at least three weeks and maybe more depending on length of the bonus content which is still tbd.

Leave a Comment or Question