Power Pivot Grand Total Not Correct

[AgingRapidly]

The Grand Total columns in my pivot tables are not the sum of the columns when I've used ROUNDUP in measure.
Grand Total value is always less than it should be. No filters are applied.

I have to take the

each quantity forecasted,​

FCst_Qty Measure - Grand Totals correct​

=SUMX(​

FG_Forecasts,​

FG_Forecasts[FCst_Quantity])​

use that result to calculate ounces forecasted​

ForecastOz Measure - Grand Totals correct​

=[FCst_Qty]*[Fill]​

​

use that result to calculate pounds forecasted which needs to be rounded up so that we would make more rather than less.​

ForecastLbs Measure - Grand Totals incorrect and all other measures using ROUNDUP are wrong too​

=ROUNDUP(​

DIVIDE(​

[ForecastOz],​

[OzPerLb],​

0),​

0)​

I'd appreciate any help I can get with this.

Thank you

 

[JoePublic]

Grand totals are not the sum of the individual columns. They are the same calculation applied to all the data, so the rounding you have applied for each month is not occurring - you get one rounding at the overall total level. You'll need an additional measure that returns your existing measure if the month only has one value (you can use HASONEVALUE), or sums the measure for each month value if there are multiple months (i.e. it's the total). If you need more specific help, please post a sample workbook.