What is the purpose of the ALL() function in DAX?

Power BI Medium

Power BI — Medium

What is the purpose of the ALL() function in DAX?

Key points

  • ALL() affects row visibility, not value aggregation
  • It overrides user-applied filters on a table
  • This function is often used in combination with other DAX calculations
  • ALL() does not modify the underlying data, only the calculation context

Ready to go further?

Related questions