Showing value at Do Not Repeat Item Label Row

[sudi_arta]

I have sample data as below :

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Pro No.[/TD]
[TD="align: center"] Item No.[/TD]
[TD="align: center"] Qty PRO[/TD]
[TD="align: center"] Qty Item[/TD]
[/TR]
[TR]
[TD="align: center"]PRO01[/TD]
[TD="align: center"]Item01[/TD]
[TD="align: center"] 1000[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]PRO01[/TD]
[TD="align: center"]Item02[/TD]
[TD="align: center"] 1000[/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD="align: center"]PRO01[/TD]
[TD="align: center"]Item03[/TD]
[TD="align: center"] 1000[/TD]
[TD="align: center"]9[/TD]
[/TR]
</tbody>[/TABLE]


Then I created PivotTable from PowerPivot, which using Do Not Repeat Item Labels feature.

I have made several DAX formulas (Qty PRO column) to the results as below, but it ALWAYS FAILS.

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Pro No.[/TD]
[TD="align: center"] Item No.[/TD]
[TD="align: center"] Qty PRO[/TD]
[TD="align: center"] Qty Item[/TD]
[/TR]
[TR]
[TD="align: center"]PRO01[/TD]
[TD="align: center"]Item01[/TD]
[TD="align: center"] 1000[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]Item02[/TD]
[TD="align: center"][/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]Item03[/TD]
[TD="align: center"][/TD]
[TD="align: center"]9[/TD]
[/TR]
</tbody>[/TABLE]


PLEASE HELP....

 

[Norah]

Turning off repeating item labels will only impact the row (or column) labels, not the actual measure output. Turning it off for the Pro No field will work, but only for that field - it's not going to change the way the Qty PRO measure shows results.

Is Qty PRO related to the Item No in any way? If you want it to only show itself as a subtotal, you'll need to turn on the subtotals for the Pro No field and modify the Qty PRO measure with something like HASONEVALUE.