Forum Discussion
Totals Not Equaling Rows
Hello, I'm new to Power BI and have taken over a dashboard created by someone no longer around to ask. I am wondering why my totals are not equaling what I am adding up in the columns for Sch...
Hi Anonymous ,
That is normally the case if the aggregation used in the formula uses the distinct values. For example, Item1 in column A shows 2 and Item2 shows 3 but the total sums up to only 5. To illustrate:
ColumnA ColumnB Distinct Count per columnA Distinct Count as a whole Item1 A 3 unique items 4 unique items (A, B, C, D where C is counted once) Item1 B Item1 C Item2 D 2 unique items Item2 C You can inspect the formulas in those measure to get an idea.
Hi Anonymous ,
That is normally the case if the aggregation used in the formula uses the distinct values. For example, Item1 in column A shows 2 and Item2 shows 3 but the total sums up to only 5. To illustrate:
| ColumnA | ColumnB | Distinct Count per columnA | Distinct Count as a whole |
| Item1 | A | 3 unique items | 4 unique items (A, B, C, D where C is counted once) |
| Item1 | B | ||
| Item1 | C | ||
| Item2 | D | 2 unique items | |
| Item2 | C |
You can inspect the formulas in those measure to get an idea.
Thank you for providing an example. This is something I will need to be aware of go forward and try to find a way to show the proper totals