cancel
Showing results for
Did you mean:
Helper I

## Using COUNTAX to count contacts between certain ages

Hello everyone

I'm using the following Measure to COUNT the number of contacts who are aged between 41 & 60 years of age over around 125,000 records. The 125,000 records contain a range of ages including NULLs.

It's taking FOREVER, and I wondered if there's a better way of doing this?

age41-60 = COUNTAX(FILTER(contact,contact[sic_age] >=41 && contact[sic_age]<=60),contact[sic_age])

Many thanks
Jon

1 ACCEPTED SOLUTION
Super User

To clarify, you could create a calculated column that contains each age group (e.g., 21-40, 41-60). If you have an alternate grouping (e.g., 21-30, 31-40), you could create a second calculated column for this grouping.

3 REPLIES 3
Super User

Try this measure:

``````age41-60 =
CALCULATE (
COUNTROWS ( contact ),
contact[sic_age] >= 41
&& contact[sic_age] <= 60
)``````

You could also create calculated columns for each age group.

Super User

To clarify, you could create a calculated column that contains each age group (e.g., 21-40, 41-60). If you have an alternate grouping (e.g., 21-30, 31-40), you could create a second calculated column for this grouping.

Helper I

Thank you @DataInsights , the Calculated Column worked perfectly.

Announcements

#### Launching new user group features

Learn how to create your own user groups today!