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...
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.
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?
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.
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.
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 :)
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?
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.
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 ) )
No one can explain like you Chandeep. Kudos.. Totally clear and concise
Clear and concise explanation of the KEEPFILTER function. Great video and very helpful. Keep up the great work on DAX
You are my best place to come for DAX :D. Thank you, keep on the greatness.
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...
This is the best explanation of the KEEPFILTERS function in the entire world.
Thank you
Glad it helped!
I don't usually comment but your videos are too good to resist.
I am so happy that you did not resist this time 🙏😁
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.
You have the best explanations. Good work
Glad it was helpful!
Could you explain the difference between keepfilter and filter wrt performance. Why keepfilter is preferred over filter to get only matching values
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?
Using keepfilter with the combination of ALL makes explicitly sense of what keepfilter does in real scenario.
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.
Thank you! Wonderful video, Sir:)
Glad you like it!
Thanks Chandeep for detailed explanation
Thanks Sandeep for avidly watching all my videos.
Cheers
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.
what is the difference between filter and keepfilter will both do same work almost can u please explain this?
Chandeep whats the difference between ALL and ALLSELECTED
thanks so much for clear explanation of keep filters
Happy to help!
Two questions: why is your number formatting is: "00,00,000" and also is this better than using Filter function from a performance perspective?
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 :)
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?
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.
Thank you chandeep explanation was very helpful and easy to catch new subscriber🙂
Hey I am glad you found it helpful & welcome to Goodly! :D
Amazing explanation!! 👍
Thanks!
Thanks for perfect explanation.
I like the one line explanation to begin with
Thank you mister
Awesome!
I want to show on card last year sales , current year sales and next year sales , how can I do ?
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 ) )
@@GoodlyChandeep Down thanks.., and your video is awesome..