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
[TABLE="width: 1019"]
<tbody>[TR]
[TD]Surgeon[/TD]
[TD]Surgeon Specialty[/TD]
[TD]Enc - Financial Class_Desc[/TD]
[TD]CM Surgeries[/TD]
[TD]Prior CM Surgeries[/TD]
[TD]*Variance CM to PM[/TD]
[/TR]
[TR]
[TD]DE, B ML[/TD]
[TD]Orthopedic Surgery[/TD]
[TD]AUTO[/TD]
[TD="align: right"]2 [/TD]
[TD][/TD]
[TD="align: right"]2 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]CONTRACT[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]9 [/TD]
[TD="align: right"](7)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MANAGED MEDICARE[/TD]
[TD="align: right"]2 [/TD]
[TD][/TD]
[TD="align: right"]2 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MEDICAID[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]17 [/TD]
[TD="align: right"](15)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MEDICARE PART A AND B[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]0 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]WORKERS COMPENSATION[/TD]
[TD="align: right"]4 [/TD]
[TD][/TD]
[TD="align: right"]4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Orthopedic Surgery Total[/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"](14)[/TD]
[/TR]
[TR]
[TD]DE, B ML Total[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"](22)[/TD]
[/TR]
[TR]
[TD]ROW, E JR[/TD]
[TD]Orthopedic Surgery[/TD]
[TD]AUTO[/TD]
[TD="align: right"]5 [/TD]
[TD="align: right"]1 [/TD]
[TD="align: right"]4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]CONTRACT[/TD]
[TD][/TD]
[TD="align: right"]11 [/TD]
[TD="align: right"](11)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MANAGED MEDICARE[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]7 [/TD]
[TD="align: right"](5)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MEDICAID[/TD]
[TD="align: right"]3 [/TD]
[TD="align: right"]4 [/TD]
[TD="align: right"](1)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MEDICARE PART A AND B[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]1 [/TD]
[TD="align: right"]1 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]SELF-PAY[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]WORKERS COMPENSATION[/TD]
[TD="align: right"]2 [/TD]
[TD][/TD]
[TD="align: right"]2 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Orthopedic Surgery Total[/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"](11)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Plastic Surgery[/TD]
[TD]MEDICARE PART A AND B[/TD]
[TD="align: right"]4 [/TD]
[TD="align: right"]5 [/TD]
[TD="align: right"](1)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Plastic Surgery Total[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"](10)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD](blank)[/TD]
[TD]MEDICAID[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD](blank) Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ROW, E JR Total[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"](21)[/TD]
[/TR]
</tbody><colgroup><col><col><col><col span="3"></colgroup>[/TABLE]
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
[TABLE="width: 1019"]
<tbody>[TR]
[TD]Surgeon[/TD]
[TD]Surgeon Specialty[/TD]
[TD]Enc - Financial Class_Desc[/TD]
[TD]CM Surgeries[/TD]
[TD]Prior CM Surgeries[/TD]
[TD]*Variance CM to PM[/TD]
[/TR]
[TR]
[TD]DE, B ML[/TD]
[TD]Orthopedic Surgery[/TD]
[TD]AUTO[/TD]
[TD="align: right"]2 [/TD]
[TD][/TD]
[TD="align: right"]2 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]CONTRACT[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]9 [/TD]
[TD="align: right"](7)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MANAGED MEDICARE[/TD]
[TD="align: right"]2 [/TD]
[TD][/TD]
[TD="align: right"]2 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MEDICAID[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]17 [/TD]
[TD="align: right"](15)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MEDICARE PART A AND B[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]0 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]WORKERS COMPENSATION[/TD]
[TD="align: right"]4 [/TD]
[TD][/TD]
[TD="align: right"]4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Orthopedic Surgery Total[/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"](14)[/TD]
[/TR]
[TR]
[TD]DE, B ML Total[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"](22)[/TD]
[/TR]
[TR]
[TD]ROW, E JR[/TD]
[TD]Orthopedic Surgery[/TD]
[TD]AUTO[/TD]
[TD="align: right"]5 [/TD]
[TD="align: right"]1 [/TD]
[TD="align: right"]4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]CONTRACT[/TD]
[TD][/TD]
[TD="align: right"]11 [/TD]
[TD="align: right"](11)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MANAGED MEDICARE[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]7 [/TD]
[TD="align: right"](5)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MEDICAID[/TD]
[TD="align: right"]3 [/TD]
[TD="align: right"]4 [/TD]
[TD="align: right"](1)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MEDICARE PART A AND B[/TD]
[TD="align: right"]2 [/TD]
[TD="align: right"]1 [/TD]
[TD="align: right"]1 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]SELF-PAY[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]WORKERS COMPENSATION[/TD]
[TD="align: right"]2 [/TD]
[TD][/TD]
[TD="align: right"]2 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Orthopedic Surgery Total[/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"](11)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Plastic Surgery[/TD]
[TD]MEDICARE PART A AND B[/TD]
[TD="align: right"]4 [/TD]
[TD="align: right"]5 [/TD]
[TD="align: right"](1)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Plastic Surgery Total[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"](10)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD](blank)[/TD]
[TD]MEDICAID[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD](blank) Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ROW, E JR Total[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"](21)[/TD]
[/TR]
</tbody><colgroup><col><col><col><col span="3"></colgroup>[/TABLE]