Implementing Analytics Solutions Using Microsoft Fabric — Question 93

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?

Answer options

• A. when the FILTER function uses a nested calculate function
• B. when the FILTER function references a measure
• C. when the FILTER function references columns from multiple tables
• D. when the FILTER function references a column from a single table that uses Import mode

Correct answer: D

Explanation

The correct answer is D because using KEEPFILTERS in this scenario allows Power BI to maintain existing filters more efficiently, reducing execution time. Options A, B, and C do not leverage the specific performance benefits provided by KEEPFILTERS in the context of a single table with Import mode.