topic Re: DAX Filter - greater-than or equal is not working in DAX Commands and Tips

DAX Filter - greater-than or equal is not working

chinthada — Mon, 25 May 2020 23:18:29 GMT

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

Re: DAX Filter - greater-than or equal is not working

smearp — Tue, 26 May 2020 00:39:12 GMT

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".

Re: DAX Filter - greater-than or equal is not working

Anonymous — Tue, 26 May 2020 00:48:25 GMT

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

Re: DAX Filter - greater-than or equal is not working

chinthada — Wed, 27 May 2020 02:38:04 GMT

It seems this was data related problem...