I look for an issue to get a daily average. It means so simple...but I didn't solve it! 😞
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,
Go to Solution.
SUM ( 'Imputations & Frais'[Nb heures] ),
DISTINCTCOUNT ( 'Imputations & Frais'[Date] ),
ALL ( 'Imputations & Frais' )
View solution in original post
That's my measure that doesn't work as I would like :
H/jour = DIVIDE(SUM('Imputations & Frais'[Nb heures]);DISTINCTCOUNT('Imputations & Frais'[Date]))
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]))
I get the same result... 😞
I thought I did it...actually no 😄
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.