How to average a measure across a group

[AaronGlenn10]

All Stars:

Trying to take an average of a calculated measure across a group.  The calculated measure is a YTD % delta - 'TABC'[YTD_%_Delta] over previous year's YTD, and the group is a group of cities - 'TABC'[location_city(groups)]

Thank you!

~AGS

[Jihwan_Kim · Accepted solution]

Hi, @AaronGlenn10 

Please correct me if I wrongly understood your question.

Please try the below.

newmeasure = averagex (values ('TABC'[location_city(groups)]), [your measure])

Or, if it is OK with you, please share your sample pbix file's link, then I can try to come up with a more accurate measure.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[AaronGlenn10]

Thank you.  I think this is on the right path, but it's returning a huge #. I need to calculate on a yearly basis and I think it's calculating across all years.  Do I need to add some sort of date parameter?

~AGS

[Jihwan_Kim]

Hi, @AaronGlenn10 

Thank you for your feedback.

Without seeing the sample pbix file, it is difficult for me to tell.

Is your year-filter doing something on the report page? Or, do you just want a specific year's result?