Forum Discussion
Problem calculating with decimal numbers
I have a table in which I have decimal numbers as seen below: As you can see it is formatted as decimal number. While creating a measure I`m trying to calculate & count rows where the values ...
ok, I found a solution. Had to change my regional settings on my laptop from English (USA) to English (Europe). For some reason this was messing up the whole calculation
rohit1991
Super User
Super UserHi Anonymous
Could you please try below Step :
1.Change the column’s data type to the correct format >> Decimal Number
2. Create Calculated column:
Flag = IF('Sample Data'[Number] > 0.9, 1, 0)
3. You can create measure as well. It gives you aggregate outcome:
TEMP =
CALCULATE(
COUNTROWS('Sample Data'),
'Sample Data'[Number] > 0.9
)