Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |