Grand Total Showing Incorrectly in Pivot Table

[PShingadia]

Hi All:

I am new to DAX and written the following formula which analyses the data correctly but the Grand Total on Pivot table does
not equal to the sum of the individual rows.



Adjusted Sample Find:=if(DIVIDE([Sum of Sample Count Find], [Weight])>=[Rounding Limit], ROUNDUP(DIVIDE([Sum of Sample Count Find], [Weight]), 0), ROUNDDOWN(DIVIDE([Sum of

Sample Count Find], [Weight]), 0))


Would be grateful for any help in either rewriting the formula or explaining why total differs.

Thanks

Prav

 

[Matt Allington]

... but the Grand Total on Pivot table does
not equal to the sum of the individual rows

The Grand total is not the addition of the items above. The grand total is the formula executed in the current filter context. You probably need to use the Sumx to solve this problem

Read my article here https://exceleratorbi.com.au/use-sum-vs-sumx/

 

[PShingadia]

The Grand total is not the addition of the items above. The grand total is the formula executed in the current filter context. You probably need to use the Sumx to solve this problem

Read my article here https://exceleratorbi.com.au/use-sum-vs-sumx/

Thanks very much - this really helped!