Forum Discussion
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...
Delete the first reference to election date on line 3, you only need to compare that to the MAX.
Delete the first reference to election date on line 3, you only need to compare that to the MAX.
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!