Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average calculation using a measure

Hi all,

 

Just needed some help in calculating an average using a measure I did before. Right now, my measure is: total cases = COUNT('Cases' [Case reference number]). I just need to calculate an average of it and I have only six months worth of data.

 

Thanks,

Shawn

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , This seems like a case of the Level of detail. Avg after what level , say month then

     

     

    Monthly Avg=

    averageX(Values(Table[Month Year]), calculate(COUNT('Cases' [Case reference number])) )

     

    City Avg

     

    averagex(Values(Table[City]), calculate(COUNT('Cases' [Case reference number])) )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , This seems like a case of the Level of detail. Avg after what level , say month then

     

     

    Monthly Avg=

    averageX(Values(Table[Month Year]), calculate(COUNT('Cases' [Case reference number])) )

     

    City Avg

     

    averagex(Values(Table[City]), calculate(COUNT('Cases' [Case reference number])) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for your help amitchandak. I am looking to calculate monthly average and your solution works well!