Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power pivot-grand total

Hi,

 

I'm new to power pivot and something weird is happening in my report and I hope that you guys have the answer.

I build a pivot table from one excel sheet and I create few measures in the power pivot.

1.SumOfShipment=CALCULATE(SUM(Table1[sumSales]),ALLEXCEPT(Table1,Table1[product],Table1[division],Table1[ShipmentNum]))

2.TotalShipment:=CALCULATE(DISTINCTCOUNT(Table1[ShipmentNum]),NOT(ISBLANK(Table1[ShipmentNum])))

3. AboveMinShipment=CALCULATE([TotalShipment],FILTER(Table1,[MinforShipment]<=[SumOfShipment]))

 

I create the following pivot table:

RAWS:

product, division, ShipmentNum

values:

AboveMinShipment

 

The result I'm getting is correct except for the "grand total" row, it adds 1 to the total.

meaning, if I sum up the result in the column "AboveMinShipment" I get the result 20 and the result in the grand total row is 21, how it can be possible?

 

 

Need Help

1 Reply

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Belle, 

    If possible, could you please inform me more detailed information(such as your sample data and expected output)? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.