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...