cancel
Showing results for
Did you mean:
Highlighted
Helper IV

## Daily average

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I

@bapt69

```H/jour =
DIVIDE (
SUM ( 'Imputations & Frais'[Nb heures] ),
CALCULATE (
DISTINCTCOUNT ( 'Imputations & Frais'[Date] ),
ALL ( 'Imputations & Frais' )
)
)```
Regards,
Zubair

5 REPLIES 5
Highlighted
Helper IV

That's my measure that doesn't work as I would like :

H/jour = DIVIDE(SUM('Imputations & Frais'[Nb heures]);DISTINCTCOUNT('Imputations & Frais'[Date]))

Highlighted
Super User I

HI @bapt69

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]))

Regards,
Zubair

Highlighted
Helper IV

Sorry no

I get the same result... 😞

Highlighted
Super User I

@bapt69

```H/jour =
DIVIDE (
SUM ( 'Imputations & Frais'[Nb heures] ),
CALCULATE (
DISTINCTCOUNT ( 'Imputations & Frais'[Date] ),
ALL ( 'Imputations & Frais' )
)
)```
Regards,
Zubair

Highlighted
Helper IV

I thought I did it...actually no 😄

It works!

Thank you!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors
Users online (636)