When used as a table function, and depending on the parameters used, the ALL function returns a table that contains all of the values of a column, all of the values of a combination of columns, or all of the rows of a specified table. More importantly, the ALL function ignores any filters or slicers that may be set, effectively removing them from the current filter context.
However, when the ALL function is used as a parameter with the CALCULATE and CALCULATETABLE functions, its functionality is different. Instead of returning a table that contains all of the values of a specified column or combination of columns, it removes the specified columns from the current filter context.
The syntax for the ALL function ...
