Using COUNTAX to count contacts between certain ages

[jonclay]

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

[DataInsights]

@jonclay,

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.

[DataInsights · Accepted solution]

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.

[jonclay]

Thank you @DataInsights , the Calculated Column worked perfectly.