cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bfj4800 Frequent Visitor
Frequent Visitor

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

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

 

Datetable.pngMembertable.pngRelations.png

 

Results.png

 

5 REPLIES 5
BiBra Member
Member

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

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 Frequent Visitor
Frequent Visitor

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

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

bfj4800 Frequent Visitor
Frequent Visitor

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

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

bfj4800 Frequent Visitor
Frequent Visitor

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

Anyone to see a solution for this one, please?

BiBra Member
Member

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

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