メジャーを含む Microsoft Power Bl セマンティック モデルがあります。メジャーでは、複数の計算関数とフィルター関数が使用されます。 メジャーのパフォーマンスを評価しています。 どのユースケースでフィルター関数を keepfilters 関数に置き換えると実行時間が短縮されますか?
正解:A
The KEEPFILTERS function modifies the way filters are applied in calculations done through the CALCULATE function. It can be particularly beneficial to replace the FILTER function with KEEPFILTERS when the filter context is being overridden by nested CALCULATE functions, which may remove filters that are being applied on a column. This can potentially reduce execution time because KEEPFILTERS maintains the existing filter context and allows the nested CALCULATE functions to be evaluated more efficiently.