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.
Hello everyone,
I look for an issue to get a daily average. It means so simple...but I didn't solve it! 😞
Ex :
Date1 - Something1 - Nb1
Date2 - Something2 - Nb2
Date2 - Something3 - Nb3
I would get average = SUM(Nb from Something1)/DISTINCTCOUNT(Date) -> So Nb1/2!
But I get Nb1/1!!
When I ask it on general result, it's ok cause there is a Nb on each date, but when I ask it by Something, it count only the dates where there is Something (so 1 date instead of 2 dates).
Am I clear?
Thanks you for all your support,
Baptiste
Solved! Go to Solution.
@Anonymous
H/jour = DIVIDE ( SUM ( 'Imputations & Frais'[Nb heures] ), CALCULATE ( DISTINCTCOUNT ( 'Imputations & Frais'[Date] ), ALL ( 'Imputations & Frais' ) ) )
That's my measure that doesn't work as I would like :
H/jour = DIVIDE(SUM('Imputations & Frais'[Nb heures]);DISTINCTCOUNT('Imputations & Frais'[Date]))
HI @Anonymous
I hope I understood the question correctly
Try replacing DistinctCount with only COUNT
H/jour = DIVIDE(SUM('Imputations & Frais'[Nb heures]);COUNT('Imputations & Frais'[Date]))
Sorry no
I get the same result... 😞
@Anonymous
H/jour = DIVIDE ( SUM ( 'Imputations & Frais'[Nb heures] ), CALCULATE ( DISTINCTCOUNT ( 'Imputations & Frais'[Date] ), ALL ( 'Imputations & Frais' ) ) )
I thought I did it...actually no 😄
It works!
Thank you!
User | Count |
---|---|
76 | |
74 | |
61 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |