Multiple Choice Difficult

QWhich DAX function is primarily used to modify the filter context of a calculation?

ID: #25395 Introduction to Power BI 2 views

Question Info

#25395Q ID

DifficultDifficulty

Introduction to Power BITopic

Start Quiz on This Topic

Your Answer

Select All That Apply

Tick every correct option, then press Check Answer.

A SUM() ✔ ✖
B CALCULATE() ✔ ✖
C COUNTROWS() ✔ ✖
D DISTINCT() ✔ ✖

Correct Answer

Explanation

Option B is correct because CALCULATE() is one of the most important DAX functions. It evaluates an expression in a modified filter context. For example, it can calculate sales for a specific region, year, or product category regardless of the current report filters. Understanding CALCULATE is considered essential for advanced Power BI development. Option A performs aggregation only. Option C counts rows. Option D returns distinct values. None of them can directly modify filter context like CALCULATE().

Continue Practice

Previous Question Next Question

Share This Question

Challenge a friend or share with your study group.

QWhich DAX function is primarily used to modify the filter context of a calculation?

Select All That Apply

Explanation

Share This Question

Related MCQ Questions