Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))))
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?
We can put it this way - I want the sum of active members in each month.
Anyone to see a solution for this one, please?
A quick clarification: Do you want to show the "indmeldelses" date or just whom are active members?
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???
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |