Problem with Grand Total of PowerPivot

[sophea_tum]

Hi all,

I am new in the power pivot when i matching with 2 table in the power pivot and make it in pivot in excel then the grand total is correct but wen I make the filter in the pivot the grand total still remind the same. please help.

there is the example that show in the Pivot.

Before filter:
Group.......Items......QTY
A..............A1............1
A..............A2............6
Subtotal A................7
B..............B1............3
B..............B2............6
B..............B3............1
SubTotal B..............10
Grand Total............17

After filter:
Group.(A)...Items......QTY
A................A1............1
A................A2............6
Subtotal A..................7
Grand Total..............17


After filter the grand total should be 7 not 17.
Please Help!

 

[Matt Allington]

It's not possible to help you with the information provided. Have a read of this article I wrote and see if that helps.

When to use SUM vs SUMX in DAX

if not, you will need to provide information about your tables, relationships and measures before anyone could assist.