cancel
Showing results for
Search instead for
Did you mean:
Highlighted
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

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

## 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!
Regular Visitor

## Re: Filter between two values

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

Super User

## Re: Filter between two values

Sometimes it's the small things

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
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

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

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

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 318 members 3,431 guests
Recent signins:
Please welcome our newest community members: