Hi,
I have a strange one with rounding of decimal values.
Total Sales = SUMX( Sales [Quantity] * Sales [ Unit Amount ] )
Inside the Sales table, the Unit Amount column has amounts with 4 decimal values. Its rounding the Unit Amount to 2 decimal values before it calculates the row with SUMX.
Example Unit Price 8.2476 x Quantity 777 = $6,408.39. Except I am getting $6,410.25
I have the formatting on the table column set to Decimal values and 4 decimal places.
Any help?