Forum Discussion
Force decimal instead of integer
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.
DataType isn't enabled as an option, only Format (which I just changed to "Decimal Number" and it had no effect). I see the DataType option on calculated columns, but not on measures.
To simplify the problem, I created a measure as this:
Store Coverage = 10/3
Which displays value 3 on my table and card, even though I've selected "Decimal Number" as the format in the ribbon above.
Screenshot is attached for reference-- any ideas? =)
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).
Thanks guys!! That did the trick.
