In Power BI, what is the purpose of the KEEPFILTERS() function in DAX?

Power BI Hard

Power BI — Hard

In Power BI, what is the purpose of the KEEPFILTERS() function in DAX?

Key points

  • KEEPFILTERS() modifies the filter context
  • It retains existing filters when adding new ones
  • This function is distinct from ALL() which removes filters
  • KEEPFILTERS() does not lock slicers or force visuals to ignore interactions

Ready to go further?

Related questions