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
bhanu_gautam
Super User
Super UserAnonymous , Try using
DAX
CALCULATE(
COUNTROWS('Quality Self-Assessment and Audit Tracker'),
FILTER(
'Quality Self-Assessment and Audit Tracker',
'Quality Self-Assessment and Audit Tracker'[Self assessment score] > 0.9
)
)
If it still gives error try using round inside filter