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.
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])