Struggling with unexpected total rows in Power BI? Learn how to handle total row calculations using DAX, ensuring they reflect the logic you need. In this video, we’ll guide you through common pitfalls, explain filter context, and demonstrate how to use advanced DAX techniques like virtual tables and X functions to fix incorrect totals. Perfect for beginners and intermediate users ready to level up their DAX skills!
👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/
00:00 - Introduction: Total Rows in Power BI
01:24 - Understanding the Example Data Model
02:28 - Adding Conditional Logic to Revenue
03:32 - Total Row Discrepancy Explained
05:30 - Identifying the Total Row
07:18 - Implementing Logic for Total Row Detection
08:13 - Creating a Virtual Table
10:29 - Using SUMX for Correct Totals
12:18 - Final Results: Adjusted Total Row
12:42 - Virtual Mentoring Program Info
Let's connect:
✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#PragmaticWorks