So the benefit of KEEPFILTERS over FILTERS is KEEPFILTERS creates a temp table with only the column you are filtering on vs FILTER will create a temp table with all columns unless you use VALUES with it?
Hi! Not Microsoft but my opinion: I think the reason we have overlapping with DAx Measures is due to development or evolution of DAX language. I have seen how they have created new functions to facilitate the use of the language which helps beginners tremendously. For us that have been around for a while is a bit confusing, but if you use those new functions like SELECTEDVALUE, you will soon fall in love with them. My two cents... Happy Friday! /Ruth
Hi ruth, no , because they are not always right, there are errors, and i dont like these “ wizards” because they dont explain anything and if you want to change anything, you still have to learn dax.
What is the difference between filters and keep filter, if keep filters behave like a filter then what is the use of keep filters, when should we use give me some brief explanation
Thanks for this, Ruth! Using this, I solved a pain in the ass problem of calculating the Q difference from last week. :) I didn't even know if that would work with this function, however it did! :)
I'm using PBI and I find most of the formulas to be very cryptic. Hopefully I will learn the syntaxes of building complex formulas soon enough, though this was a very much needed quick-win. I didn't even think this was possible to adapt so easily. All I had to do was to alter a DATEADD formula by adding keepfilters for it to work :).
It takes time to learn DAX and i dont think even the most seasoned developers fully master it, but it is worth the learning curve as you can do amazing things with it :) /Ruth
Hi Ruth, Thanks for your great videos! Quick question: how would you do the following: Calculate ( Sum (ColumnValues), Keepfilters (week=Max (week))) And considering I have on the slicers multiple values selected for "week" field... I get the following error: a function MAX has been used in a true/false expression... blah blah
Ah cool. Syntax sugar for a FILTER(VALUES(column)., expression... ) ... At the moment I prefer not to use these kind of shortcuts because I want to ensure I understand precisely what I'm asking for and what I expect the engine to do. Still, thanks!
I really ignored this function when reading the definitive guide to dax... This 6 mins video saved me one hour of reading and understanding
Glad you found it useful :)
/Ruth
So the benefit of KEEPFILTERS over FILTERS is KEEPFILTERS creates a temp table with only the column you are filtering on vs FILTER will create a temp table with all columns unless you use VALUES with it?
Exactly
Ruth, again great explanation, but........ question for microsoft >>>>> why are there so many ways to accomplish the same result? Keep it basic...
Hi! Not Microsoft but my opinion:
I think the reason we have overlapping with DAx Measures is due to development or evolution of DAX language.
I have seen how they have created new functions to facilitate the use of the language which helps beginners tremendously.
For us that have been around for a while is a bit confusing, but if you use those new functions like SELECTEDVALUE, you will soon fall in love with them.
My two cents...
Happy Friday!
/Ruth
Thx for reaction....little question, do you ever use quick measures?
Nop, but if I was a beginner I would definitely give them a go. Do you?
/Ruth
Hi ruth, no , because they are not always right, there are errors, and i dont like these “ wizards” because they dont explain anything and if you want to change anything, you still have to learn dax.
Same here, but remember that quick measures are not for us :)
/Ruth
This is great! Quick measures sometimes adds in a “keepfilters” aspect and i never knew what it did!
Neat function right?
/Ruth
What is the difference between filters and keep filter, if keep filters behave like a filter then what is the use of keep filters, when should we use give me some brief explanation
Thanks for this, Ruth! Using this, I solved a pain in the ass problem of calculating the Q difference from last week. :) I didn't even know if that would work with this function, however it did! :)
Yey!!!! Powerpivot is powerful indeed :)
/Ruth
I'm using PBI and I find most of the formulas to be very cryptic. Hopefully I will learn the syntaxes of building complex formulas soon enough, though this was a very much needed quick-win. I didn't even think this was possible to adapt so easily. All I had to do was to alter a DATEADD formula by adding keepfilters for it to work :).
It takes time to learn DAX and i dont think even the most seasoned developers fully master it, but it is worth the learning curve as you can do amazing things with it :)
/Ruth
Hi Ruth,
Thanks for your great videos!
Quick question: how would you do the following:
Calculate (
Sum (ColumnValues),
Keepfilters (week=Max (week)))
And considering I have on the slicers multiple values selected for "week" field...
I get the following error: a function MAX has been used in a true/false expression... blah blah
Hi! The best way to get support is to post in the power bi community. Thanks!
/Ruth
Ah cool. Syntax sugar for a FILTER(VALUES(column)., expression... ) ...
At the moment I prefer not to use these kind of shortcuts because I want to ensure I understand precisely what I'm asking for and what I expect the engine to do.
Still, thanks!
I agree with you, it is better to learn the default behavior :)
/Ruth
Hola tu expresión Filter, es mas eficiente así:
CALCULATE([No_Employees,
FILTER(Employee, Employee[Status]= "Terminated" && Employeed[Dep.] = "LA"))
Usando Keepfilters queda así:
CALCULATE([No_Employees,
KEEPFILTERS(Employee[Status]= "Terminated" && Employeed[Dep.] = "LA"))
Awesome video/series. First one on PBi i watched e2e.
😊😊
/Ruth
great video
excellent