Forum Discussion
Round Total Value Only
Hello, I have a large table that requires accuracy to two decimal places for each line in a column. However, since the table is so large the overall total is showing a very visually wide number, ...
Never mind! Fixed it:
Sales KG = if(DISTINCTCOUNT('Sales Line'[Item No.]) > 1, fixed(sum('Sales Line'[KG]), 0), sum('Sales Line'[KG]))
You can try something like this:
IF(
HASONEVALUE( TABLE[COLUMN]),
[MEASURE],
ROUND([MEASURE], 0)
)