Power BI DAX Tutorial (20/50) - What is REMOVEFITERS Function in DAX

[@pravinupadhyay2046]

ALL() returns a table e.g All(Table[Column]) will return a table of 1 column with all distinct values of Table[Column], whereas REMOVEFILTER() is only used to remove the already available filter context from that column, the most important thing is, this Function can only be used inside CALCULATE() or CALCULATETABLE(). If you have a very large model you would see the performance difference between using ALL and REMOVEFILTER.. it is very easy to understand as by the name and definition itself that which one would be efficient, but NO they are not same.

[@AnalyticswithNags]

Thanks for the highlighting

[@AnilSharma-sg4qw]

Amazing work, thanks for all your effort and time! This DAX series has everything one needs.

[@AnalyticswithNags]

Yes. Share this channel with friends and colleagues

[@AnilSharma-sg4qw]

@@AnalyticswithNags sure 😊

[@stephanweaver1960]

I don't get it - all removes all filters but RF only specified filter, right??

[@AnalyticswithNags]

You are correct. Remove filters are performance efficient

[@dilipgoud321]

hello sir what is allcrossfilter . if possible make a video on that.........

[@AnalyticswithNags]

Will make a video on that soon

[@piyushpathak7311]

Sir I have question if you reply then it will be great, as I have a IPL data and I want to see the name of final winner team of year 2020 by using DAX , I have written my DAX but not able to get the deserved result any help from your side will be great, I am learning DAX from your channel you are great..

[@AnalyticswithNags]

chat.whatsapp.com/FzPDzFs4Cd09ANEhi0vu9B join this group and post your queries there..someone in the group will respond

[@Laxmansree]

HI Piyush. can you please ipl data source.

[@dilipgoud321]

Hello sir how to make resume of power bi i am new to this it i am planning to keep a resume.How to keep real time project and Description in bi resume pls let me know sir..

[@AnalyticswithNags]

Join this group someone will help Analytics With Nags t.me/analyticswithnags