Power BI Skills

Wednesday, April 7th, 2021

Welcome to your Use the Calculate Function

This DAX function [select all that apply]

Total Sales for 2015 = CALCULATE(SUM('Sales OrderDetails'[Total Price]), YEAR('Sales OrderDetails'[orderdate]) = 2015)

Will be equal to SUM('Sales OrderDetails'[Total Price]) when the view has a filter on orderdate = 2015

Overrides the order date filter context

Will return the same value regardless of other dimension filters such as region, manager, or product

The CALCULATE function

override certain portions of the context

ignores all filters in the view

Learn Power BI