Counting rows within a period (startdate and enddate) in members table

[bfj4800]

Hi there

On behalf of the Danish Football Federation, I need your help 🙂
I want to count the members in our 1650 associated clubs within a period, but I can't figure out the measure.

I've tried with this measue, but it dosn't seem to be the right result:

A medlemmer = CALCULATE(COUNTROWS(DBU_BI_Aktive_Spillere);FILTER(DBU_BI_Aktive_Spillere;([Indmeldelsesdato i klub] <= LASTDATE(Datoer[Dato])&&[Udmeldelsesdato i klub]>=FIRSTDATE(Datoer[Dato]))))

[BiBra]

I do not seem to find the fault in this? When implementing the measure in my own report, it seems to be correct.

What makes you think it is not correct?

[bfj4800]

We can put it this way - I want the sum of active members in each month.

[bfj4800]

Anyone to see a solution for this one, please?

[BiBra]

A quick clarification: Do you want to show the "indmeldelses" date or just whom are active members?

[bfj4800]

I know for a fact, that this club has about 500-600 members. Whar I want is to show how many members there are pr. month.
Maybe this measure doesn't count the rows without a "Memberout"-date???