cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
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

@bapt69

 

 

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


View solution in original post

5 REPLIES 5
Highlighted
Helper IV
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

HI @bapt69

 

I hope I understood the question correctlySmiley Tongue

 

Try replacing DistinctCount with only COUNT

 

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

Regards,
Zubair


Highlighted

Sorry no

I get the same result... 😞

Highlighted

@bapt69

 

 

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


View solution in original post

Highlighted

I thought I did it...actually no 😄

It works!

Thank you!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

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)