Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
5 years ago
Solved

difference between removefilters(), all()

Hi, I'm confused with the use of all() and removefilters(). I wonder if someone can give me an explanation about the two calendar filters: all() vs removefilters().   I have written two measures u...
Need Help
powerbi_zone's avatar
powerbi_zone
Frequent Visitor
4 years ago

Hello Dear ,

Its not as complicated as you may think šŸ™‚

Differences between ALL() and REMOVEFILTERS()

REMOVEFILTERS is just an alias of ALL here, so it works in the same manner.

Basically, using only ALL() returns a table including all rows, ignoring any filters that might have been applied.

However, when ALL is used as a filter argument of CALCULATE / CALCULATETABLE, it behaves differently: it removes filters from the table and does not return a table.

To eliminate this confusing behavior of ALL, REMOVEFILTERS was introduced to replace ALL when it is used inside CALCULATE.

You can find more in this video.Hope it helps!