Forum Discussion
Active Contacts Over time.
Delete the first reference to election date on line 3, you only need to compare that to the MAX.
I've got 2 connectsionfr from the calendar into the contact,
One on Date (from the Calendar table) into Lapsed Date in the Contacts table (this is active)
and the other from Date (calendar table) into election date in the contacts table (this isn't active as it wont let me have 2 active connections)
You need to add the REMOVEFILTERS as I posted, that will remove the effect of the active relationship with the lapsed date, as that is incorrectly filtering the rows in this instance.
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)....
😕
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!