Filter between two values

[tborg]

I have 2 measusres meant to count how many advisors have 0 sales and how many have between 1-4 sales.  The below formula is meant to capture the second number, but as written it also captures those with 0 sales.  How do I modify it to capture only those with 1-4 sales?

1-4 RTA = CALCULATE(DISTINCTCOUNT(Advisors[Advisor Name]),FILTER(Advisors,Advisors[RTAs]<5))

Thanks!

[TomMartens · Accepted solution]

Hey,

guess this would work

1-4 RTA = 
  CALCULATE(
    DISTINCTCOUNT(Advisors[Advisor Name])
    ,FILTER(Advisors
      ,Advisors[RTAs] >= 1 
      && Advisors[RTAs] <=5
    )
  )

Regards

[tborg]

Thanks!  I never would have guessed the double ampersand (&&)!

[TomMartens]

Sometimes it's the small things 

[tborg]

Well, I'm new at this, so it's often the small things!  But I surely do do appreciate the help!