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]))))
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?
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???