topic Re: Keepfilters vs Filters in DAX Commands and Tips

Keepfilters vs Filters

Alex_Hasan — Sat, 28 May 2022 16:05:03 GMT

Here I have calculted two measures and they produced the same result. which one is more efficient and why?

Re: Keepfilters vs Filters

tamerj1 — Sat, 28 May 2022 16:49:52 GMT

Hi Alex_Hasan

yes becuase the first one is actually

KEEPFILTERS ( FILTER(*Product, 'Product' [Color] = "green' ) )

where here KEEPFILTERS does nothing

Re: Keepfilters vs Filters

Alex_Hasan — Sat, 28 May 2022 17:01:38 GMT

Hi tamerj1 , your answer seems confusing to me. Could you please elaborate?

Re: Keepfilters vs Filters

tamerj1 — Sat, 28 May 2022 17:23:05 GMT

Alex_Hasan

Sorry for the in accurate explanation.
CALCULATE ( [Amount], "Product' [Color] = "green" ) is actually translated into

CALCULATE ( [Amount], FILTER ( ALL ( Product), 'Product' [Color] = "green" ))

Which returns the value of green in all cells.
this is because the filter context of each cell contains the coplete product table while when using only FILTER the filter context in each cell contains only the related color therefore the intersection is empty except for green.

Re: Keepfilters vs Filters

Fowmy — Sat, 28 May 2022 17:26:13 GMT

Alex_Hasan

I would suggest you use the 1st Measure "Green Sales":

Explanation: You have effectively used KEEPFILTER here to show sales only when Green colour is visible. The most important point is, only the Product [Colour] column is used but the in the second measure, you are referring to the full Product table within the Filter function which is not efficient, also it will have the unexpected effect of expanded table.