DAX Filter - greater-than or equal is not working

[chinthada]

Hello Experts,

I have data set like below

TypeOfCall	Year	Quarter	AttnTimeNew
Urgent	2020	Q1	6.2
Non-Urgent	2020	Q3	9.1
Urgent	2020	Q2	18
Non-Urgent	2020	Q1	20

I am writing a Dax measure using filters for AttnTimeNew.

com-test = CALCULATE(COUNTA('VW_Water'[CC_MASTER__ID]), FILTER('VW_Water','VW_Water'[AttnTimeNew]>=18)).

For this filter, it should give the result of "2" as I'm using greater than or equal operators. But it gives results as "1". If I change above Dax query as 17,  FILTER('VW_Water','VW_Water'[AttnTimeNew]>=17), then it will give the result of "2". 

The source column is in decimal number.

 

If I change it to a whole number I can see the results correctly. Hope you will help to resolve this issue.

thanks

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[smearp · Accepted solution]

Hello-

I recreated your table (I added a column called CC_MASTER_ID, since that's what your measure is counting):

For the measure, I copied your measure:

and for the result, I get the expected "2".

[chinthada]

It seems this was data related problem...