Forum Discussion

RichFlorida's avatar
RichFlorida
Icon for Helper V rankHelper V
2 years ago
Solved

DAX REMOVEFILTERS function

Could the REMOVEFILTERS function be used in a measure calculation to disable/remove the filter applied by a slicer on a page?

 

my report is based on an Analysis Services model.

 

Pls advise with examples?

 

Thanks!

Need Help
  • justinmartin's avatar
    justinmartin
    2 years ago

    Hey Rich,

    Yes, REMOVEFILTERS() allows you to remove the filters applied to a calculation. See the example below to see how to remove a filter coming from a slicer.

     

1 Reply

  • justinmartin's avatar
    justinmartin
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hey Rich,

    Yes, REMOVEFILTERS() allows you to remove the filters applied to a calculation. See the example below to see how to remove a filter coming from a slicer.