Taking an Average of a Measure

[mali130]

Hi Gurus,

I have created a measure which has around 5 values against 5 dates. I am looking to find a way to display the average of all those values. Please advise.

Thanks. 

[mali130 · Accepted solution]

Thanks @amitchandak you are always very kind

[mali130]

hi @amitchandak thank you so much for your input. I tried the way you mentioned but there is a small issue, the value in one of the date does not seem to be right. Please see below image, last column is calculated based on what you mentioned. Column 'OB Cases Shipped Per Lb. Hr." is calculated by dividing "Sum of Total Cases Shipped" by "Sum of Actual Worked Hours". All the values of column three and four are matching except highlighted in the image. Can you please advise why.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result very clearly.

[amitchandak]

@mali130 , try a measure like

Averagex(Values(Date[Date]), [Measure])