Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Never mind! Fixed it:

     

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Never mind! Fixed it:

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You can try something like this:

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