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!