Forum Discussion

tborg's avatar
tborg
Helper I
9 years ago
Solved

Filter between two values

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 w...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    guess this would work

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

    Regards

     

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

guess this would work

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

Regards

 

tborg's avatar
tborg
Helper I
9 years ago

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

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    Sometimes it's the small things :smileywink:

    • tborg's avatar
      tborg
      Helper I
      9 years ago

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