Count greater than 0 but less than 40 in dax using calculate count statement

[LukeA]

Hi all,

I am trying to produce a count of the number of ETA Times which are greater than 0 but less than 40. I have provided my code below:

ETA 0 - 40 =

VAR _ETA40 = CALCULATE(COUNT('D Incidents'[ETA to Incident in Minutes]),FILTER('D Incidents','D Incidents'[ETA to Incident in Minutes] > 0))

RETURN

IF(ISBLANK(_ETA40),0, _ETA40)

The code above works for greater than 0 however, I need to add a statement in which will not return any number above 40. It tried adding in <=40 after the >0 as seen below:

ETA 0 - 40 =

VAR _ETA40 = CALCULATE(COUNT('D Incidents'[ETA to Incident in Minutes]),FILTER('D Incidents','D Incidents'[ETA to Incident in Minutes] > 0 <=40 ))

RETURN

IF(ISBLANK(_ETA40),0, _ETA40)

Any ideas on how I can tweak this so it dosent return an error?

[amitchandak · Accepted solution]

@LukeA , try like

ETA 0 - 40 =
VAR _ETA40 = CALCULATE(COUNT('D Incidents'[ETA to Incident in Minutes]),FILTER('D Incidents','D Incidents'[ETA to Incident in Minutes] > 0 && 'D Incidents'[ETA to Incident in Minutes] <=40))
RETURN
IF(ISBLANK(_ETA40),0, _ETA40)