Totals Not Equaling Rows

[Anonymous]

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.

[danextian · Accepted solution]

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.

[Anonymous]

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

[yaowen]

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