Calculating to specific decimal places without rounding

Question

Hello Community Team,&nbsp;I am having struggles with rounding the numbers. I don't want it to round after 2 decimals, but I am unsure of the dax grammar to make it so. Please find the snapshot. Unfortunately, explaining to the management team rounding issues, it still confuses them.&nbsp;&nbsp;I would just like the Share Change= 0.9 - 1.0 = -0.1 (not the -0.2 shown from rounding).&nbsp;My share formulas are:Share Change = [Current Share] - [LY Share]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Current Share =var Dollars = sum('Legacy YTD'[Current Dollars])var ACV = CALCULATE(sum('Legacy YTD'[Current Dollars]), ALL('Legacy YTD'[Supplier]))return&nbsp; &nbsp; DIVIDE(dollars*100,acv,0)&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LY Share =var Dollars = sum('Legacy YTD'[YA Dollars])var ACV = CALCULATE(sum('Legacy YTD'[YA Dollars]), ALL('Legacy YTD'[Supplier]))return&nbsp; &nbsp; DIVIDE(dollars*100,acv,0)&nbsp;I have tried to search within here and it's not exactly working based on what I have seen for the solved solutions.&nbsp;Thank you in advance.

owenauger · Accepted Answer

Hi&nbsp;9kRPM&nbsp;
If you would like the value of Share Change displayed in the visual to be equal to the difference between the displayed (i.e. rounded) values of Current Share and LY Share, I would suggest:
Share Change display =
ROUND ( [Current Share], 1 ) - ROUND ( [LY Share], 1 )
I would suggest just using this measure for display in visuals, but use the original Share Change in any calculations.
&nbsp;
Does this work for you?
Regards

Forum Discussion

Calculating to specific decimal places without rounding

2 Replies

Related content

Rounding

CALCULATE Challenge - Round 1

How to search specific word in table filter Calculations

No CALCULATE Challenge -- Round #2

No CALCULATE Challenge -- Round #2b