Matt Allington takes us through the REMOVEFILTERS() function in DAX:
Recently Microsoft introduced a new function in DAX called REMOVEFILTERS(). This is a very useful and well named function and it does exactly what its name suggests. Its purpose is to act as a table filter parameter inside CALCULATE() as shown in the following example.
Total Sales All ProductsREMOVEFILTERS() =CALCULATE([Total Sales],REMOVEFILTERS(Products))
Read on to see how this compares to the prior/alternative solution and for more information on REMOVEFILTERS().