Forum Discussion

jonclay's avatar
jonclay
Helper IV
4 years ago
Solved

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
 
 
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    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

  • DataInsights's avatar
    DataInsights
    Super User
    4 years ago

    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's avatar
      DataInsights
      Super User
      4 years ago

      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.