
Ultimate access to all questions.
You are working with a Microsoft Power BI semantic model that incorporates several measures. These measures utilize multiple instances of the CALCULATE function in conjunction with the FILTER function. As part of optimizing your Power BI model, you are assessing the performance of these measures. In what scenario will substituting the FILTER function with the KEEPFILTERS function lead to a reduction in execution time?
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