Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |