What is the use of CALCULATE in DAX?
💡 Model Answer
CALCULATE is the core function that changes the filter context of a measure. It evaluates an expression within a modified set of filters, allowing you to perform context transitions, add or remove filters, and apply complex filtering logic. For example, CALCULATE(SUM(Sales), Year = 2023) sums sales only for 2023. It also supports advanced features like ALL, ALLEXCEPT, and FILTER to override or extend the current context. Without CALCULATE, measures would simply use the existing filter context, limiting analytical flexibility.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.
Get Assisting AI — Starts at ₹500