cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tborg Regular Visitor
Regular Visitor

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

Accepted Solutions
Super User
Super User

Re: Filter between two values

Hey,

 

guess this would work

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

Regards

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
4 REPLIES 4
Super User
Super User

Re: Filter between two values

Hey,

 

guess this would work

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

Regards

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
tborg Regular Visitor
Regular Visitor

Re: Filter between two values

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

Super User
Super User

Re: Filter between two values

Sometimes it's the small things Smiley Wink

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
tborg Regular Visitor
Regular Visitor

Re: Filter between two values

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 113 members 1,466 guests
Please welcome our newest community members: