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)

Overrides the order date filter context

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

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

The CALCULATE function

ignores all filters in the view

override certain portions of the context

Learn Power BI