Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tborg
Helper I
Helper I

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 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!

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey,

 

guess this would work

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

Regards

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

4 REPLIES 4
TomMartens
Super User
Super User

Hey,

 

guess this would work

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

Regards

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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

Sometimes it's the small things Smiley Wink



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.