Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Active Contacts Over time.

Hi there.  I'm having an issue plotting a graph of number of active members over time.  Its very similar to this topic, but they're getting different results: Solved: Active Clients over time - Mic...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Delete the first reference to election date on line 3, you only need to compare that to the MAX.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks, I've done that an the measure appears to be working:

But then the same number apears against all the dates in teh table:

I would expect this number to change as people are elected (start date) or lapse (end date)....

😕

 

johnt75's avatar
johnt75
Super User
4 years ago

Delete the first reference to election date on line 3, you only need to compare that to the MAX.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    Ahhh yes that did it!!!  So my final measure code was:
     
    CORRECT Active Members =
    CALCULATE(COUNTROWS('CE vwContact (2)'),
        'CE vwContact (2)'[Rics_ElectionDate] <= MAX('BI vwCalendar (2)'[Date]),
        OR(
    'CE vwContact (2)'[Rics_LapsedDate] >= MIN('BI vwCalendar (2)'[Date]),
    ISBLANK('CE vwContact (2)'[Rics_LapsedDate])),
    REMOVEFILTERS('CE vwContact (2)')
    )
     
    I'm gonna need to check the numbers but that appears to have done it!! many thanks!