Measures looks fine except for Total

[Anonymous]

Hi,

I have created the following measure showing number of new members after a clinic for different clubs. I get good results accept for the total which clearly isn't the sum of all new members. 

The tables GJDBD-clinics and Instroom_leden are joined many-to-one on CLUBCODE, so I excepted it to work fine.

GJDBD Instroom =

var vanaf=min(Verenigingen[Datum_eerste_clinic])

return

CALCULATE([# Instroom t/m 12 jaar],Verenigingen[Deelnemer_GJDBD],vanaf<Instroom_leden[Startdatum])

[amitchandak]

@Anonymous , Try like

GJDBD Instroom =
var vanaf=min(Verenigingen[Datum_eerste_clinic])
return
Sumx( Values([Clubcode]), CALCULATE([# Instroom t/m 12 jaar],Verenigingen[Deelnemer_GJDBD],vanaf<Instroom_leden[Startdatum]) )

or

GJDBD Instroom =
var vanaf=min(Verenigingen[Datum_eerste_clinic])
return
CALCULATE(Sumx( Values([Clubcode]), [# Instroom t/m 12 jaar]),Verenigingen[Deelnemer_GJDBD],vanaf<Instroom_leden[Startdatum]) )

[Anonymous]

@amitchandak Here an overview of the complete datamodel

As I told I get the right figures by CLUBNAAM but the total number is wrong. When I make a breakdown by a variable from the table Instroom_leden e.g. geslacht the number also don't change.

[Anonymous]

@amitchandak I rewrote the measure, but still get the same results. I'm guessing that something might be wrong with the datamodel. What do you think?

GJDBD Instroom =

var vanaf=min(Verenigingen[Datum_eerste_clinic])

return

Sumx( Values(Instroom_leden[Clubcode]), CALCULATE([# Instroom t/m 12 jaar],Verenigingen[Deelnemer_GJDBD],vanaf<Instroom_leden[Startdatum]) )