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/
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.Showcase Report – Contoso By SpartaBI
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
SpartaBI Logo
When using inside calculate there is not much difference .Also there is some context behind why the REMOVEFILTERS function was introduced.If i try to explain it here the blog will become too lengthy .See this video till the end ,Hope things become more clearer !
Cheers !