Power BI Quizzes

Practice Quizzes
Thanks!
Thanks!

Power BI Quizzes

Accelerate your Career and Get Certified

Use the Calculate Function

Wednesday, April 7th, 2021

Welcome to your Use the Calculate Function

Questions are based on this module

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

override certain portions of the context

ignores all filters in the view

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Δ

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC