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 whole numbers (0.3 => 0 and 1.6 => 2)
My measure is using the / divide operator which should result in a decimal but its only returning an int, and no casting function appears to be available when I'm looking..
My measure looks like "Store Coverage = inventory_waypoint[Waypoints Captured Today] / inventory_waypoint[Enabled_Waypoints]"
I tried to see if there might be some way to edit in the query editor window but didn't see anything there either (especially since these calculated columns/measures don't even show up there). I'm new to PowerBI so any help is very appreciated 😃
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.