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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Best way to round up or down a % figure after divide calculation

Hi,

 

I am calculation a conversion from MRL to MQL and from MRL to SAL.

 

I would like to round up or down the % figures. What would be the best way to do that.

 

This is my code. Would using the round function help? 

How would I add this in to my code.

Lead Conversion MRL to MQL = DIVIDE('Lead'[Lead MRL count],'Lead'[Lead MQL count])

 

HarryB_0-1670332206910.png

 

4 REPLIES 4
Greg_Deckler
Super User
Super User

@Anonymous Try:

Lead Conversion MRL to MQL = ROUND(DIVIDE('Lead'[Lead MRL count],'Lead'[Lead MQL count]),5)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

HI @Greg_Deckler ,

 

Thank you for your response.

 

I tried your solution but there was no change at all to the figures.

 

Would you be able to suggest something else which might help.

 

Kind regards,

 

HarryB

Anonymous
Not applicable

@Greg_Deckler 

 

This is what I would like to see.

 

Sum of Lead Conversions MRL to MQL

74%

35%

13%

60%

 

Does that help?

 

@Anonymous What results are you expecting?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.