cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alex_Hasan
Helper II
Helper II

ALL vs REMOVEFILTERS

Hello, I have a question about using ALL and REMOVEFILTERS functions. Here you can see the perecentage of sales using those two functions and the results are the same.  So, which one is the correct way to calculate? 

All.JPGremovefilters.JPG

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@Alex_Hasan this is not something I can really explain in a post message here 🙂
Basically when you want to remove filters through calculate (like in your example) then you can use each one. It's the same.
When you want to create a table for some purpose that has all the values regardless of filters, then you use ALL.
Check out these 2 videos:
https://www.youtube.com/watch?v=GIP5dzBmUxc&t=2s

https://www.sqlbi.com/tv/removefilters-dax-guide/



2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@Alex_Hasan As a 2nd argument in calculate (the way you used it in your example) there is no difference at all 🙂
ALL can aslo be used as Table funciton where REMOVEFILTERS has only the calculate modifier role. (ALL can do both).
REMOVEFILTERS was added few years back to make it more understandable instad writing ALL there in the calculate modifer scenarios. 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

Hi @SpartaBI , could you please elaborate when to use ALL and when to use Removefilters? 

SpartaBI
Community Champion
Community Champion

@Alex_Hasan this is not something I can really explain in a post message here 🙂
Basically when you want to remove filters through calculate (like in your example) then you can use each one. It's the same.
When you want to create a table for some purpose that has all the values regardless of filters, then you use ALL.
Check out these 2 videos:
https://www.youtube.com/watch?v=GIP5dzBmUxc&t=2s

https://www.sqlbi.com/tv/removefilters-dax-guide/



2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors