DAX KEEPFILTERS Function

[@vrajjindal38]

No one can explain like you Chandeep. Kudos.. Totally clear and concise

[@CJ-jc8tn]

Clear and concise explanation of the KEEPFILTER function. Great video and very helpful. Keep up the great work on DAX

[@chadweber1582]

This is the best explanation of the KEEPFILTERS function in the entire world. Thank you

[@GoodlyChandeep]

Glad it helped!

[@ThuHuongHaThi]

You are my best place to come for DAX :D. Thank you, keep on the greatness.

[@apamwamba]

Very clearly explained. in short, on the same color column, you first remove all filters and use filter to produce a table with black only. Then you use AND to combine with others colors. so you essentially have black only. You are adding external filter to the calculate filter. If you dont use KEEPFILTERS, You are replacing the external filter with the CALCULATE filter. We are told is a more efficient way of doing things but hey will leave those details to GOODLY...

[@saifullahkhan3776]

I don't usually comment but your videos are too good to resist.

[@GoodlyChandeep]

I am so happy that you did not resist this time 🙏😁

[@GodParticleZero]

You have the best explanations. Good work

[@GoodlyChandeep]

Glad it was helpful!

[@williamarthur4801]

Using the 'added ' column to illustrate what was happening was very helpful. Too many so called introductions over complicate things using large complex data sets which make it hard to see what's actually goin going on.

[@susantadas8213]

Using keepfilter with the combination of ALL makes explicitly sense of what keepfilter does in real scenario.

[@sandeepreddy7687]

Thanks Chandeep for detailed explanation

[@GoodlyChandeep]

Thanks Sandeep for avidly watching all my videos. Cheers

[@sandeepreddy7687]

Honestly your videos give indepth explanation about each dax function. Love your videos and explanation. I always recommend your videos to my friends and colleagues.

[@Laxmanmane007]

thanks so much for clear explanation of keep filters

[@GoodlyChandeep]

Happy to help!

[@KgasS]

Thanks for this video. The way of understanding, the KEEPFILTERS can be thought in this way, is it applies an AND logic with the visual filter. For example, Hey I am Black(KEEPFILTERS argument), are you(Visual element)?. If so do the calculation or the result will be obiviously blank.

[@sr5726]

Could you explain the difference between keepfilter and filter wrt performance. Why keepfilter is preferred over filter to get only matching values

[@Milhouse77BS]

I like the one line explanation to begin with

[@mohdmuzammil3059]

Thank you chandeep explanation was very helpful and easy to catch new subscriber🙂

[@GoodlyChandeep]

Hey I am glad you found it helpful & welcome to Goodly! :D

[@Tessie1993]

Hi Goodly, thanks for all the explaining! I was wondering though how it's possible to feed ALL(Products[Color]) as the first argument to SUMX. Because I thought that SUMX only takes a table as a first argument and ALL(Products[Color]) only returns the Color column right?

[@vishaljhaveri7565]

Thank you! Wonderful video, Sir:)

[@GoodlyChandeep]

Glad you like it!

[@sayi77]

Thanks for perfect explanation.

[@spilledgraphics]

Two questions: why is your number formatting is: "00,00,000" and also is this better than using Filter function from a performance perspective?

[@GoodlyChandeep]

1. Since my keyboard is set to local Indian Settings that is the way we apply commas in India. 2. Yes for any standard column filters I'd prefer using KEEPFILTERS and also that is faster :)

[@abhishektg6321]

what is the difference between filter and keepfilter will both do same work almost can u please explain this?

[@vrajjindal38]

Chandeep whats the difference between ALL and ALLSELECTED

[@chahineatallah2636]

Amazing explanation!! 👍

[@GoodlyChandeep]

Thanks!

[@Darknesslc3]

so basically it is a AND condition function that allows external filter. In your visual the filter context of other color than "Black", is "Red & Black", "Silver & Black", "Yellow & Black"... etc. Am I correct?

[@GoodlyChandeep]

Yes you are right. KEEPFILTERS will add the external filters as well. External filters mean the filters other than the one written in your Dax formula.

[@KirillBezzubkine]

Thank you mister

[@majidismayilov4027]

Awesome!

[@Vaibhav.dange05]

I want to show on card last year sales , current year sales and next year sales , how can I do ?

[@GoodlyChandeep]

I am assuming that you have a Total Sales Measure and a Date Table. Write 2 Measures.. LY Sales = CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( Date[Date] ) ) NY Sales = CALCULATE ( [Total Sales], DATEADD( Date[Date], 1, Year ) )

[@Vaibhav.dange05]

@@GoodlyChandeep Down thanks.., and your video is awesome..