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 Scheduled Hours and Sick Hours.
Any assistance on what is happening and how to fix this would be great.
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.
3 Replies
It is suggested to cut the table data to make it clearer. Try this code to create two new Measures:
ScheduledHours = SUM([Scheduled Hours])
SickHours = SUM([Sick Hours])
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.
