Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help in calculating averages

Hey guys,   Just needed some help with performing calculation on averages. I need to calculate an average for the total and if possible monthly as well. Just wondering how can i actually achieve th...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    It looks like that [YearMonth] are separate columns in your table.

    You will need to unpivot the table to below format:

    Then you could create a measure like below:

    measure = calculate(average([value]),filter(allexcept(table,[assigened to]),[attribute]<>"total"))

     

    Best Regards,

    Jay

Shaurya's avatar
Shaurya
Icon for Memorable Member rankMemorable Member
4 years ago

Hi Anonymous,

 

I don't think you should use count for averages. Here's a way to calculate average for months, let's say January and February in this case and total average.

 

January Average = CALCULATE(AVERAGE('Table'[Values]),FILTER('Table','Table'[Month]="Jan"))

 

February Average = CALCULATE(AVERAGE('Table'[Values]),FILTER('Table','Table'[Month]="Feb"))

 

Total Average = CALCULATE(AVERAGE('Table'[Values]))

 

Result:

 

 

Works for you? Mark this post as a solution if it does!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hey Shaurya,

    Sorry its because of the dataset Im working on, i don't have a column that is showing the total number for each month hence I have to use count of [case reference number] in order to calculate my total number of cases. Hope that clarifies what I am finding.

     

    Regards,

    Shawn