Calculating average of values from a measure which have been filtered by a slicer

[eacy]

Hi,

How do I calculate the average of a measure.

Total A (Avg) = SUMX('jiradb changeitem';[Total A])

The "Total Assignments"  will be manipulated by a slicer so the Total and the number of rows included will change all the time.

I want the new "Total A (Avg)" to change along with "Total A" when the slicer change.

Any suggestions is appriciated.

[v-qiuyu-msft]

Hi eacy,

According to your description, you have created a measure called “Total A”. Then you want to calculate average values of a measure based on slicer, right?

In DAX, to return average values all numbers in a column, we can use AVERAGE function. In your scenario, as the Total A is measure, we are not able to use AVERAGE function to return average values directly. We need to create a new column with the same DAX which is used by "Total A" measure. Then we can create a new measure with AVERAGE function. Please refer to screenshots below:

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

[electrobrit]

@v-qiuyu-msft your screen shots are gone. I'm thinking your solution would also help me with an issue I am having.

[sixtoquiles]

Any one find the screen-shot?