Forum Discussion
Inaccurate results by Decimal Numbers
Community ChampionAnonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Greg_Deckler Hi, Thanks for your response. I have a measure that calculates a division and gives a decimal number and I used the Divide function. Then I use its result to find out if it is an integer or has a digit in the decimal part.
Divide(([M]*60),[C])*Divide([R],(60+S))
M, C, and R are Measures that are calculated before and return an integer. S is a Variable that is defined in this measure, it is also an integer.
I used the decimalpart=mode(result,1) to find out if it has a decimal part.
if (decimalpart>0&&decimalpart<=0.5,int(result)+0.5,(if(decimalpart>0.5,int(result)+1, result)
(I tested also floor, round, roundup, and rounddown functions.
I got the result from this measure as I expected. You can see the result in the middle column.
But When I use the result in the other measures it behaves differently. The third column is the result of another measure and shows the sum of the first and second columns.