Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

     

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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

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

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      HI Anonymous

       

      I hope I understood the question correctly:smileytongue:

       

      Try replacing DistinctCount with only COUNT

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Sorry no

        I get the same result... :(