The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi there,
I have a measure1 which after calculations returns a decimal number. This number sometimes is an integer but altogether is a decimal, when it shows directly on one table visual, it shows the exact expected number, when I use it in IF condition and I want to see if it's an integer, calculate a Date and when it's decimal, Calculate another Date, then I see several results for the same number.
For example, when measure1 shows 1.5 then measure2 uses 1 or 2, or even 0.5.
I tried to show measure1 directly visually and also after calculation in measure2, and even tried to see the result of floor, int, round, roundup, rounddown, Again I got several results for the same number.
I couldn't change the result of measure1 it's the exact thing that I want.
How to use decimal numbers and get accurate results?
I need your help, Thanks indeed
@Yasaman 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.
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
183 | |
80 | |
62 | |
46 | |
38 |