From the course: Power BI for Finance
Join today to access over 24,900 courses taught by industry experts.
Utilizing DAX CALCULATE function - Power BI Tutorial
From the course: Power BI for Finance
Utilizing DAX CALCULATE function
- [Instructor] The CALCULATE DAX function returns scaler values as a measure result. We can use the CALCULATE function to add conditions to our measure formulas. The CALCULATE function contains two input parameters. Let's work backwards to better understand how they work. The second parameter is the optional, but most powerful part of the calculation. It lets us set filter conditions in our DAX measure by filtering the table in play for the calculation. This includes narrowing down the filter context of the calculation or expanding it. The first function parameter is the aggregation. This can be an aggregate function like SUM or AVERAGE applied over a field, or even a measure that's already in our Power BI model. What if we want to calculate measures from other measures? One quite powerful functionality that we can tap into within DAX is we can use our measures within other measure calculations as well. We'll calculate our total tax amount by referencing the net income before taxes…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.