Calculate Function
Use the Calculate Function
The CALCULATE function is your method of creating a DAX measure that will override certain portions of the context that are being used to express the correct result.
For instance, if you want to create a measure that always calculates the total sales for 2015, regardless of which year is selected in any other visual in Power BI, you would create a measure that looks like the following sample:
Total Sales for 2015 = CALCULATE(SUM('Sales OrderDetails'[Total Price]), YEAR('Sales OrderDetails'[orderdate]) = 2015)Notice how the measure is named Total Sales for 2015. When you use the CALCULATE function to override the context, it is helpful to name the measure in a way that describes exactly how you are overriding it. In this example,
When both measures are added to the previous visual they will resemble the following screenshot.
As shown in the preceding screenshot, Total Sales is still USD1.35 million, while the 2015 Total Sales is USD0.66 million.
When you add the other visual onto the report, as you did previously, and then select 2015, the results will look like the following image.
Microsoft Power BI: Advanced Data Analysis and Visualisation
Microsoft Power BI: Advanced Data Analysis and Visualisation
Reach your personal and professional goals
Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.
Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.
