Great video! I feel like I'm in a time machine learning about ALL, then REMOVEFILTERS lol. I feel it's best to learn it all so you understand everything no matter what functions are used in a report. Thanks Ruth!
Great thanks. I totally agree about the DAX editor. Another annoyance for me is copying+pasting to and from it (measure to new measure, Notepad to editor, DAX Formatter to editor and vis-versa) - sometimes it works, often not. I don't see what I'm doing differently each time.
Nice ! Hey Ruth ! Since the extended form of product table includes category table columns also, as they have many to one relationship, so applying removefilter on product will work for category also automayically.
Thanks for your explanation. Very clear! Thanks also for explaining ALLEXCEPT. p.s. What happened @6:56 drives me nuts many times throughout my workday.
As always good video. Min 8:50, the measure is ignoring category too because "expanded tables". I think, when you apply a function over a table, indeed, it is applying over its "expanded table". Video about this concept would be genial. I hope you confirm this point of view
I guess the same. The product table contains the expanded version of category columns. This can be easily checked do we still see the same behavior if we include just a column from the product table (as REMOVEFILTERS argument) instead of the whole product table. I couldn't find video 149 (from the download list) to test this. Please test if you could download the file. It's very useful to understand the behavior
Hi there, I often see your model is on snowflake schema, isnt it star schema the optimal model for BI analysis? I know the result will be the same but there is a performance impact
HI Dear Ruth , I hope all are right , REMOVEFILTERS [ Column ]- The column that you want to clear filters on.We used REMOVEFILTERS [ProductName].There is not any filter on ProductName column for me .Because Product filter Sales.But we want to clear filter on Sales. However this measures return the same result but what is difference : REMOVEFILTERS [ProductName] and REMOVEFILTERS [SALES] ???
Hello Ruth, Thanks as always for your great well explained videos. You mentioned that the removefilters will also effect the percentage per product, why and how?
Again 10mins of pure GOLD! I have a question is there any way to remove all the relationships from a table? like Crossfilter, but without specifying the exact Column names involved in the relationship?
Q&A Ruth. Necesito calcular Market Share de venta y utilizo ALL, pero sí debo filtrar por fecha para comparar la venta total del período selecionado con la selección de la sucursal de ventas en particular. Ejemplo. Cual es el Market Share de la sucursal "X" en enero de 2020?. Espero haberme explicado bien. Aprecio tu apoyo, gracias!
I assume REMOVEFILTERSEXEPT will follow then next... :-). For new people to DAX for sure helpful, for old stagers.... I do not think.... Have a nice weekend and Thumbs Up !!!
it's not working for me, still only showing the sum per category and not ignoring the category filter even though that's what is inside the all/remove filter function :(
Ahhh I figured it out! It’s cause I had other columns that were filtering in the same way as the category column, as in “category order” and “category colour”. So I threw all 3 inside the all/remove filter expression and it worked a treat :)
Great video! I feel like I'm in a time machine learning about ALL, then REMOVEFILTERS lol.
I feel it's best to learn it all so you understand everything no matter what functions are used in a report. Thanks Ruth!
Agreed !!
You never fail us, Ruth! Thanks.
Happy Friday!
/Ruth
Thank you for your simple and profound tutorial!
each time, i worry you might break into uncontrollable laughter. 😄
I might one day 😂😂
Great thanks. I totally agree about the DAX editor. Another annoyance for me is copying+pasting to and from it (measure to new measure, Notepad to editor, DAX Formatter to editor and vis-versa) - sometimes it works, often not. I don't see what I'm doing differently each time.
You have to keep your mouse cursor in the editor when you copy or paste, otherwise it won't take effect. Very annoying.
I thought it was only me, we need to raise this to MS so they can fix it, drives me nuts!
/Ruth
Thanks for sharing another useful knowledge, Ruth...
And thanks for watching :)
/Ruth
Nice ! Hey Ruth ! Since the extended form of product table includes category table columns also, as they have many to one relationship, so applying removefilter on product will work for category also automayically.
Wonderful:)
/Ruth
Excellent videos thank you
Really helpful..thanks... i was also trying to remove filters of other table2 linked to table1.
Thanks for your explanation. Very clear! Thanks also for explaining ALLEXCEPT.
p.s. What happened @6:56 drives me nuts many times throughout my workday.
As always good video.
Min 8:50, the measure is ignoring category too because "expanded tables". I think, when you apply a function over a table, indeed, it is applying over its "expanded table". Video about this concept would be genial. I hope you confirm this point of view
I did this video a while back, I will check and let you know :)
/Ruth
I guess the same. The product table contains the expanded version of category columns. This can be easily checked do we still see the same behavior if we include just a column from the product table (as REMOVEFILTERS argument) instead of the whole product table. I couldn't find video 149 (from the download list) to test this. Please test if you could download the file. It's very useful to understand the behavior
Hi there, I often see your model is on snowflake schema, isnt it star schema the optimal model for BI analysis? I know the result will be the same but there is a performance impact
Thanks,! I don't know if I will use ALL for percentage calculations now. Hard to explain to others and this is 100x more clear
It is, the hard part is remembering that is there! ;)
/Ruth
I think the snowflake schema is the reason of the result of category doesn't change, all attributes related to product dimension will be same
Nice, thank you, Ruth!
HI Dear Ruth ,
I hope all are right ,
REMOVEFILTERS [ Column ]- The column that you want to clear filters on.We used REMOVEFILTERS [ProductName].There is not any filter on ProductName column for me .Because Product filter Sales.But we want to clear filter on Sales. However this measures return the same result but what is difference :
REMOVEFILTERS [ProductName] and
REMOVEFILTERS [SALES] ???
Hello Ruth, Thanks as always for your great well explained videos.
You mentioned that the removefilters will also effect the percentage per product, why and how?
Mmmm, where do I say that?
/Ruth
Great!!!! as usual
🥳🥳
Thanks Ruth, an interesting new function indeed
It certainly is, hopefully a lot more like this one will come along.
/Ruth
Again 10mins of pure GOLD!
I have a question is there any way to remove all the relationships from a table? like Crossfilter, but without specifying the exact Column names involved in the relationship?
Q&A Ruth. Necesito calcular Market Share de venta y utilizo ALL, pero sí debo filtrar por fecha para comparar la venta total del período selecionado con la selección de la sucursal de ventas en particular. Ejemplo. Cual es el Market Share de la sucursal "X" en enero de 2020?. Espero haberme explicado bien. Aprecio tu apoyo, gracias!
Great video...
Thanks
Another great thing about removefilters() is that doesn't agregate data after remove filters, like ALL() does
Thanks :)
/Ruth
it is so great :) thank you
I assume REMOVEFILTERSEXEPT will follow then next... :-). For new people to DAX for sure helpful, for old stagers.... I do not think.... Have a nice weekend and Thumbs Up !!!
Habits are hard to break, I always forget about new functions. This one, I would love to adopt , let’s see if I manage :)
/Rutg
Could I use ALLEXCEPT?
Don't bother Ruth, it was REMOVEFILTER! is working fine now. Thanks anyways, nice week
it's not working for me, still only showing the sum per category and not ignoring the category filter even though that's what is inside the all/remove filter function :(
Ahhh I figured it out! It’s cause I had other columns that were filtering in the same way as the category column, as in “category order” and “category colour”. So I threw all 3 inside the all/remove filter expression and it worked a treat :)
A function name that describes what it actually does? I'm shocked. I didn't even think that was possible.
lol, we all learn ;)
Does RemoveFilters perform better than All?
Use the Analyser and dicover! (:
In my mind it should as it removes filters without creating a virtual table , but testing on different models is the best way to know.
/Ruth
As soon as you I saw this I changed my ALL() to REMOVEFILTERS(). Still trying to digest All, AllExcept ...
Bravo!!!
Great feature of this new function... but hard to learn the path and context!
Yeah, that is what makes DAX ... interesting... to say it nicely ;)
/Ruth
It's crazy thing ...quite overwhelming ..
totally confusing because of introducing too many functions in dax...
😖
Mmhhh, that's puzzling...
shame you didn't use removefilters(products[productname]) and see if it still ignored categoryid
Next time 🤞