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

@bapt69

 

 

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

Regards
Zubair

Please try my custom visuals

View solution in original post

5 REPLIES 5
bapt69
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]))

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

Please try my custom visuals

Sorry no

I get the same result... 😞

@bapt69

 

 

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

Regards
Zubair

Please try my custom visuals

View solution in original post

I thought I did it...actually no 😄

It works!

Thank you!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.