M365 Show -  Microsoft 365 Digital Workplace Daily

M365 Show - Microsoft 365 Digital Workplace Daily

Microsoft Data Pulse: Power BI, Fabric, Purview

Step-by-Step Guide to Fixing Incorrect Total Rows in Power BI

Mirko Peters - Microsoft MVP's avatar
Mirko Peters - Microsoft MVP
Jul 09, 2025
∙ Paid

Have you ever felt confused when the total in your Power BI report just doesn't add up the way you expect? You might think Power BI should simply sum the numbers like Excel, but that's not how it works. Power BI looks at data type, context, and even the type of formula you use. Sometimes, a DAX formula recalculates at the total row instead of giving you…

User's avatar

Continue reading this post for free, courtesy of Mirko Peters - Microsoft MVP.

Or purchase a paid subscription.
© 2026 Mirko Peters · Publisher Privacy ∙ Publisher Terms
Substack · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture