Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Average

So I am trying to show average handle time per day with bars and the average of the month with a line. So I wrote a dax fuction but when I want to see the day by day it ended being the quantity of the bars which makes senses so I am stuck. I also do not want to use all since it will not work with any filter if do so.

 

So for the bar ir drag the column Select average but for the líne I am not sure what fax function i should use so i get the average of the month. I dont want yo use "ALL" since it would not work with Any filter 

 

AHT = AVERAGE(Base[duracion_minuto])

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    Try the below measure

     

    Calculate(AVERAGE(Base[duracion_minuto]), allexcept(Base,FORMAT(Base[date],"YYYY-MM")))

    or

    Post the sample data

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

    Use the line and clustered column chart and put handle time in the line values section select average as shown below.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous  i am usi g average gor the bars so i can ser the daily average but u Wanna compare the daily average with the monthly average 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous 

        Try the below measure

         

        Calculate(AVERAGE(Base[duracion_minuto]), allexcept(Base,FORMAT(Base[date],"YYYY-MM")))

        or

        Post the sample data