Project Botticelli

CALCULATE Function Purchase this course

25 November 2017 · 174 views

Mastering DAX Workshop

CALCULATE is by far the most important, useful, and complex function of the DAX language. In reality, the function itself is an easy one. It only performs a few tasks, but the number of scenarios where CALCULATE is necessary, along with the complexity of the formulas that can be written with CALCULATE, make a full chapter absolutely necessary.

By using CALCULATE, you can modify the filter context that evaluates a DAX expression. You can modify filters at the column granularity level, and you can replace or combine existing filters with new ones.

CALCULATE also generates a context transition when called in a row context. You will see some practical examples of using CALCULATE to calculate ratios and percentages. You will also find out that variables are not affected by CALCULATE.

You will be able to apply the same concepts to CALCULATETABLE, which is similar to CALCULATE but returns a table instead of a single value.

Log in or purchase access below to the premium version of this content.

Purchase This Course or Full Access Subscription

Single Course


Access this course for its lifetime*.
Subscription Best Value


Access all content on this site for 1 year.
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Online Courses