MDFT Academy Quizzes

You have a Microsoft Power BI semantic model that contains measures. The measures use multiple CALCULATE functions and a FILTER function.

You are evaluating the performance of the measures.

In which use case will replacing the FILTER function with the KEEPFILTERS function reduce execution time?

Choose the correct answer from the options below.

Explanations for each answer:

When the FILTER function uses a nested CALCULATE function is incorrect. KEEPFILTERS cannot be used with nested CALCULATE functions as it uses Boolean expressions, which have this restriction. FILTER must be used in this case.
When the FILTER function references a column from a single table that uses Import mode is correct.
When the FILTER function references columns from multiple tables is incorrect. KEEPFILTERS cannot be used when referencing columns from multiple tables as it uses Boolean expressions, which have this restriction.
When the FILTER function references a measure is incorrect. KEEPFILTERS cannot be used when referencing measures as it uses Boolean expressions, which have this restriction.

Exam Preparation Quiz