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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
smizgier
Frequent Visitor

Trouble with number formats

Hello,

 

I'm having a weird problem when switching between number format for a Measure created by me.

 

The formula is DIVIDE(DISTINCTCOUNT(tablahechos[idGarantiaMacal]);DISTINCTCOUNT(tablahechos[idLoteoMacal]))

 

When I set is as a percentage it shows 130% which is correct. But when I try using decimal number with 2 decimal after comma it shows 1,00 which is not correct.

 

Any help?

 

Thanks in advance!

4 REPLIES 4
Shahid12523
Memorable Member
Memorable Member

If you want to show 1.30 instead of 130%, keep Decimal number format.

If you want 130 → multiply by 100 in DAX:

 

Measure = DIVIDE(DISTINCTCOUNT(tablahechos[idGarantiaMacal]), DISTINCTCOUNT(tablahechos[idLoteoMacal])) * 100


Then format as Decimal number with 2 decimals.

 

Key point: Percentage formatting just multiplies the value by 100 for display; decimal formatting shows the raw fraction.

Shahed Shaikh
WillT
Community Admin
Community Admin

Hi - are you still seeing this problem? We made a lot of changes in the last couple of months around formatting, you are now able to control the number of decimal places etc. shown through the modelling ribbon and formatting pane. If you're still running into problems you can either reply here or Send a Frown from within Power BI Desktop. Thanks!

Srry for late answer,

 

I used the "Fixed" formula and I solved the issue. I haven't tryed the new format features in that model.

 

Cya

Haegi
Advocate V
Advocate V

Hi,

 

It's possible to have a sample of youre data set with this measure ?

 

Regards.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.