The CALCULATE Function in DAX
IC1380

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

Exam/Certificate

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

Instructor

Randy Minder

5.0 Average Rating

3 Reviews

19 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 architect (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence, and Power BI. I have 20 years of software development experience using a variety of Microsoft technologies, mostly C#. I was a 2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure. StackOverflow reputation of 40,200 (top 1%).

Student Feedback

New Course - Not Enough Reviews Yet

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

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Business