Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |