Power pivot-grand total

[Anonymous]

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?

[dax]

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.