Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
54 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
115 | |
42 | |
41 | |
26 | |
22 |