Power Pivot Table row detail does not match Column Totals

[tbobolz]

Hi all,

Office 2016, I have a power pivot built with custom measures. The row detail does not list every item, but when it totals at the column, it is correct. I have not been able to figure out why this is happening. There are no filters on and the measures do not exclude anything.

I am hoping someone has encounter this and has a suggestion.

Thanks
Terry

Surgeon	Surgeon Specialty	Enc - Financial Class_Desc	CM Surgeries	Prior CM Surgeries	*Variance CM to PM
DE, B ML	Orthopedic Surgery	AUTO	2		2
		CONTRACT	2	9	(7)
		MANAGED MEDICARE	2		2
		MEDICAID	2	17	(15)
		MEDICARE PART A AND B	2	2	0
		WORKERS COMPENSATION	4		4
	Orthopedic Surgery Total		14	28	(14)
DE, B ML Total			14	36	(22)
ROW, E JR	Orthopedic Surgery	AUTO	5	1	4
		CONTRACT		11	(11)
		MANAGED MEDICARE	2	7	(5)
		MEDICAID	3	4	(1)
		MEDICARE PART A AND B	2	1	1
		SELF-PAY
		WORKERS COMPENSATION	2		2
	Orthopedic Surgery Total		14	25	(11)
	Plastic Surgery	MEDICARE PART A AND B	4	5	(1)
	Plastic Surgery Total		4	14	(10)
	(blank)	MEDICAID
	(blank) Total
ROW, E JR Total			18	39	(21)

<tbody>
</tbody><colgroup><col><col><col><col span="3"></colgroup>