Differences between ALLSELECTED and KEEPFILTERS - Unplugged #33

While ALLSELECTED and KEEPFILTERS are two very different DAX filter modifiers, in certain scenarios they seem to be alternatives to obtain the same result.
Starting from a case like that, we clarify the differences between the two using several practical examples.



#unplugged

[PHILIPROYBENEDICTLOUIS]

Whiteboard explanation helped me to understand more clearly, a humble suggestion is please do use that whiteboard with at least 2 examples with different data set. Thanks for helping us with great content

[williamrodriguez]

Excellent video!
The subtle implications (e.g., when showing brand AND color in the visual) really help report authors understanding of potential results for future analysis (e.g., Allselected works at brand level, but not color).
Again, brilliant as always - thanks!

[Nalaka-Wanniarachchi]

Great One as always.I suppose on the last few minutes what Marco tried to say on ALLSELECTED is, No matter what the selections are made onthe external slicers, you would be get the sum of { "Red ", "Green", "Blue" }, thinking those have been selected externally. .If I select Red and Blue as in this example i would get the sum of those two colours not three colours.ALLSELECTED, ALLWays Quite tricky.

[allmazd]

This explanation is probably the best that I heard about this function. Thank you very much!

[sauravsinha]

I would like to say Thank you as you have used white board and explained in the best way a Teacher could please explain each concepts in the same way . I am ur fan now

[jasondavidsondata]

Great explanation! This has helped me understand the two options. Thanks for that.

[psz]

After watching half of this video I was already enlightened, thank you so much, I did struggle to understand the difference :D

[MilhouseBS]

Following up the matrix explanation with the Whiteboard one helped, thanks. I think I'm (finally) starting to reallly understand KEEPFILTERS.

[prasad]

It was your first video i watched and liked it. Your explanation was so smooth and understandable

[augustotanaka]

Nice video as always, clear and concise! Thanks Marco!

[micobree]

If we add VALUES('Product'[Color]) as additional filter argument of Calculate in Trendy Colors 1 we get the same result as for Keepfilters, but ofcourse, using Keepfilters is better, more clear and simple. Thank you for great example and explanation

[ДмитрийЦеляков-фъ]

Thank you very much for your great explanations, I'm a fan now)

[thevenom]

Both of you are the best.No other words :)

[김차수-ku]

thank you for your great video. i am always confused. but this video help remind a of recap between allselected and keep filters!!! thank you very much

[JonathanCHANAL]

Thank you very much, this is really clear, very well explain, thx!

[sane]

I've read the article on SQLBI and I came to know that if you use ALLSELECTED as a Table function with a Column it will dismiss all Filters and return the entire column if there is no Shadow Filter available. But here you are putting ALLSELECTED inside the FIlter as a Table Function and it is still behaving like a Calculate Modifier. Why?
Is there anything I need to know?

[wodraeve]

Thank you for this video! An a DAX-unrelated note.. What tool are you using to zoom/draw the boxes live? Thank you.

[juanodonnell]

You said that allselected sums all the color in the calculate funtion {green, red, blue} every time but when you open the contoso product we can see that only red and blue are summed, not green.

[u]

I think it may have helped if the Contoso colours shown @9:08 included the colour green. Since Green is not selected in the visual filter but is in the measure, see what value would be placed in the cell would make it easier to understand. So, if green is not in the visual filter, will the measure include it with keepfilters?

[Bharath_PBI]

Thank you. If we use keepfilters () in trendy colours 1 measure, then results will be identical to the 2nd measure?