Forum Discussion
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...
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).
In the data model, select your measure. Click "Modeling" tab. Click the drop down for Data Type in the ribbon and switch it to "Decimal Number". Should default to 2 decimal places but you can control that as well.