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   ...
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' )
    )
)
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... :(

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        Anonymous

         

         

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