Sum Volume of first occurrence of column

[Mery]

I have this table and i need to calculate the sum of f_Population-ActiviteHab.Volume for each first occurrence of Durre column.

result = 423+2052+504

i tried this formula 

SUMX(DISTINCT('f_PresenceJournee-ActiviteHab'[Duree]); FIRSTNONBLANK('f_PresenceJournee-ActiviteHab'[f_Population-ActiviteHab.Volume]; 0))

but it doesn't work!

[harshnathani]

HI @Mery ,

Try this

SUMX(DISTINCT('f_PresenceJournee-ActiviteHab'; FIRSTNONBLANKVALUE('f_PresenceJournee-ActiviteHab'[Date]; MAX(f_PresenceJournee-ActiviteHab'[f_Population-ActiviteHab.Volume]))

or

SUMX('f_PresenceJournee-ActiviteHab'; FIRSTNONBLANKVALUE('f_PresenceJournee-ActiviteHab'[Date]; SUM(f_PresenceJournee-ActiviteHab'[f_Population-ActiviteHab.Volume]))

Regards,

Harsh Nathani