Power BI Table Totals Not Adding Up? Here’s Why!
October 4th, 2023 in Blog, DAX, PowerBI, UncategorisedEver built a table containing measures in Power BI, done a quick sanity check on your table totals and noticed they’re incorrect? Let’s explore why this may be. Here we have a simple table, built from data in the AdventureWorks database. It shows the three product categories, the Total Sales and Average Order Total of each category: As you can see, the Total Sales column adds up perfectly, but the average is just plain wrong. 19.42 +…
» Read more
