Forum Discussion

thavidu's avatar
thavidu
New Member
9 years ago
Solved

Force decimal instead of integer

I've been both trying and searching for hours, but I can't seem to figure out how to make my measure return a decimal number instead of an integer. In both Card and Table views, its only returning wh...
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    thavidu

     

    Store Coverage = 10/3  should be a decimal number already.

     

    In your screenshot, underneath "Decimal Number", Decimal Places is set to zero. Increasing that should increase the number of decimal places displayed for that measure.

     

    In general, when calculating INTEGER / INTEGER, Power BI should convert both numerator and denominator to REAL before performing the calculation (according to this page).

OwenAuger's avatar
OwenAuger
Super User
9 years ago

thavidu

 

Store Coverage = 10/3  should be a decimal number already.

 

In your screenshot, underneath "Decimal Number", Decimal Places is set to zero. Increasing that should increase the number of decimal places displayed for that measure.

 

In general, when calculating INTEGER / INTEGER, Power BI should convert both numerator and denominator to REAL before performing the calculation (according to this page).

thavidu's avatar
thavidu
New Member
9 years ago

Thanks guys!! That did the trick.