SUMMARIZE Isn’t What You Think — Here’s Proof

https://www.youtube.com/watch?v=pTI2ASgecGA&t=1s https://www.youtube.com/watch?v=NkYwwb7I3BY&t=1s https://www.youtube.com/watch?v=zInhbElc8xU&t=1s Doug asked a great question: If the SUMMARIZE function in Power BI can already create new columns, why do we still wrap it with ADDCOLUMNS? In this video, I dive into the weird behaviour of SUMMARIZE, and more importantly — show you how to uncover it using Investigative DAX. You’ll learn: ✔ What really happens inside a SUMMARIZE ✔ Why removing filters doesn’t always remove them ✔ How ADDCOLUMNS sidesteps these silent traps ✔ How to debug DAX like a pro using CALCULATETABLE, COUNTROWS, and CONCATENATEX ✔ And what changes when relationships and expanded tables are involved If you’ve ever scratched your head wondering why a DAX result feels “off” — this video walks you through the exact steps to investigate what’s going wrong and why. 📌 This video will teach you Investigative DAX — a skill that helps you break down complex issues and fix them at the root. ===== ONLINE COURSES ===== ✔️ Master 'M' in Power Query - https://goodly.co.in/learn-m-powerquery/ ✔️ Mastering DAX in Power BI - https://goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- https://goodly.co.in/learn-power-query/ ✔️ Master Excel Step-by-Step- https://goodly.co.in/learn-excel/ ✔️ Business Intelligence Dashboards- https://goodly.co.in/learn-excel-dashboards/ ===== LINKS 🔗 ===== Blog 📰 - https://www.goodly.co.in/blog/ Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/ Need my help on a Project 💻- https://www.goodly.co.in/consulting/ Download the File - https://goodly.co.in/investigative-dax-a-deep-dive-into-summarize-and-addcolumns/ ===== CONTACT 🌐 ===== Twitter - https://twitter.com/chandeep2786 LinkedIn - https://www.linkedin.com/in/chandeepchhabra/ Email - [email protected] ===== 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!