The CALCULATE Function in DAX

The CALCULATE Function in DAX

The CALCULATE function is THE core DAX function that every DAX developer uses but probably has little understanding of what's going on under the hood. Simple in its concept, and extremely powerful - CALCULATE is full of subtleties you should be aware of to get the most benefit from it and to stay out of trouble. Complete this course, and you will have a solid grasp on how to use the amazingly simple in appearance, yet exceedingly powerful function.

New Course - Not Enough Reviews Yet

Course Goal

  • Learn Context transitioning - how it can cause havoc with your CALCULATE function
  • Understand the Evaluation, Filter and Row Context
  • Recognize the many roles filtering plays in the CALCULATE function
  • Learn how to use CALCULATE modifiers
  • Understand the ALLSELECTED function and the mysterious Shadow Filter Context

Who This Training Is For

  • End users
  • IT/Business analysts
  • Project team members
  • Consultants


  • Certificate of Completion (more certification info)
  • Upon successful completion of this course, receive your The CALCULATE Function in DAX certificate


Randy Minder

5.0 Average Rating

4 Reviews

21 Students

3 Courses

Randy Minder

Siesta Key Software, LLC - Founder

Microsoft Certified Professional: Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019) Seasoned database engineer (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence, and Power BI. 20 years of software development using a variety of Microsoft technologies, mostly C#. Experience in forming and managing software development teams having successfully formed and managed development teams for two startup companies in the last 15 years.

An accomplished author of over a dozen courses on Power BI and DAX. Last seven years as a lead database engineer, business intelligence, ETL, Power BI, and Microsoft Azure data architect. 2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure. StackOverflow reputation of 43,000 (top 1%)

Student Feedback

New Course - Not Enough Reviews Yet

Language: English
Level: Beginner
Duration: 3.5 hours
Type:  Instructor-led
Category: Technology

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Business