Uploaded June 2026 | Updated September 2026, 2 weeks ago

---

Learn more about my DAX & Modeling Course - products.goodly.co.in/learn-dax-powerbi


In this video, I explain an important behaviour of the CALCULATE function in DAX.

When you add a filter inside CALCULATE, it can override the filter coming from your visual. So even if your table or matrix is showing different sales channels, CALCULATE can force the measure to calculate only for one selected channel.

We also look at what happens when two filters inside CALCULATE seem to clash, for example, when one filter removes the channel filter and another filter applies a specific channel.

This is one of those small DAX details that can completely change your result if you don’t understand the order in which filters are applied.


===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book

✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?

✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi

✔️ Power Query Course -
products.goodly.co.in/learn-power-query

✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel


===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨‍🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting


===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!