Round Total Value Only

[Anonymous]

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, and accuracy to the decimal is not relavent in the total. It is wasting space. However, the total is necessary on the table (with rounding to zero decimal places)

Is it possible to write a dax expression that will round the total but not each line?

Thank you in advance,

Michael

[Anonymous]

You can try something like this:

IF(
    HASONEVALUE( TABLE[COLUMN]),
    [MEASURE],
    ROUND([MEASURE], 0)
)

[Anonymous · Accepted solution]

Never mind! Fixed it:

Sales KG = if(DISTINCTCOUNT('Sales Line'[Item No.]) > 1, fixed(sum('Sales Line'[KG]), 0), sum('Sales Line'[KG]))