Forum Discussion
Helper IIALL vs REMOVEFILTERS
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/
Helper IIHi SpartaBI , could you please elaborate when to use ALL and when to use Removefilters?
Community ChampionAlex_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/