From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

The CALCULATE function

The CALCULATE function - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

The CALCULATE function

“

So up until this point, you might be asking yourself, what's so special about this DAX language anyway? Based on what we've looked at so far, these logical operators, these calculated columns, these text formulas, it's all extremely similar to regular old Excel syntax. In fact, in many cases, it's just about identical, with the exception that we're pointing to columns and tables instead of individual cells. And we've had a few interesting nuggets like DISTINCT COUNT is pretty cool and SWITCH is a great option, but we haven't really begun to scratch the surface of what DAX is really capable of. And that's going to change now, because now we're shifting gears into the DAX FILTER functions. And these functions are really what starts to set DAX apart as a distinct formula language. And we're going to kick it off with hands down the most popular FILTER function of all called CALCULATE. So CALCULATE basically just evaluates an expression or formula under a set of defined filters. Syntax is…

Contents