✏️ Explanatory Question

What is the difference between ALL() and REMOVEFILTERS()?

👁 4 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

Both functions remove filters.

  • ALL() returns a table and removes filters.
  • REMOVEFILTERS() explicitly clears filters.

Modern DAX development often prefers REMOVEFILTERS() because it is easier to understand.