Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
9kRPM
New Member

Calculating to specific decimal places without rounding

Hello Community Team,

 

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.

 

9kRPM_0-1697833215038.png

 

I would just like the Share Change= 0.9 - 1.0 = -0.1 (not the -0.2 shown from rounding).

 

My share formulas are:

Share Change = [Current Share] - [LY Share]

                                                                                                                                            

Current Share =
var Dollars = sum('Legacy YTD'[Current Dollars])
var ACV = CALCULATE(sum('Legacy YTD'[Current Dollars]), ALL('Legacy YTD'[Supplier]))

return
    DIVIDE(dollars*100,acv,0)
                                                                                                                                            
LY Share =
var Dollars = sum('Legacy YTD'[YA Dollars])
var ACV = CALCULATE(sum('Legacy YTD'[YA Dollars]), ALL('Legacy YTD'[Supplier]))

return
    DIVIDE(dollars*100,acv,0)
 
I have tried to search within here and it's not exactly working based on what I have seen for the solved solutions.
 
Thank you in advance.
1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

Hi @9kRPM 

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.

 

Does this work for you?

Regards


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

2 REPLIES 2
9kRPM
New Member

That worked perfectly Owen! You're awesome! Thank you. I didn't know you could use the round function in a simple calc like that.

OwenAuger
Super User
Super User

Hi @9kRPM 

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.

 

Does this work for you?

Regards


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors