cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arpitkumar2310
Frequent Visitor

show numbers as fraction

How to show a number in a "New Measure" as a Fraction or Ratio?

1 ACCEPTED SOLUTION
hugoberry
Responsive Resident
Responsive Resident

The general algorithm would be for the example that you've given.

Given : 2.5

1. Represent the number as a fraction : 25/10 

2. Find GCD(25,10) =  5

3. Divide both the numerator and denominator by GCD=5

Result: 5/2

 

It's up to you  to choose the precision. Here is my take on some DAX

Fraction =
var given=2.5
var precision=100000
return (given*precision/GCD(given*precision,precision))&"/"&(precision/GCD(given*precision,precision))

View solution in original post

7 REPLIES 7
hugoberry
Responsive Resident
Responsive Resident

The general algorithm would be for the example that you've given.

Given : 2.5

1. Represent the number as a fraction : 25/10 

2. Find GCD(25,10) =  5

3. Divide both the numerator and denominator by GCD=5

Result: 5/2

 

It's up to you  to choose the precision. Here is my take on some DAX

Fraction =
var given=2.5
var precision=100000
return (given*precision/GCD(given*precision,precision))&"/"&(precision/GCD(given*precision,precision))

Hi there, I have been using this DAX measure and it is working perfectly but I am getting a number like this for a value that should be 15/26. 

guruguruguru_0-1625580668266.png

Also, I would like it to say, for example 2/2 or 5/5 instead of 1/1 in the case of a whole number. How do I do this? 

 

Thanks so much in advance. 

Hi @hugoberry,

 

Thank you so much!! That was amazing.

Hi @arpitkumar2310

 

What do you mean exactly ?

You can use the symbol "/" or, even better, the DAX function Divide in your measures.

 

You can then display the measure as percentage in 'Modeling' > Formatting.

@Datatouille:

 

Currently I am using it as 

 

Measure = format(2.5,"0.0%")

 

Which will display it as 250.0% but I want it to display it as 5 / 2 or 5 : 2.

Hi @arpitkumar2310,

 

As there is no option to set number format for a measure to Fraction in 'Modeling' > Formatting currently, I would suggest you to submit your requirement on Power BI Ideas and vote it up to improve Power BI on this feature.Smiley Happy

 

Regards

iHi @v-ljerr-msft,

 

Sure. Thank you.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.