Print maximum of average of air quality.

[Hemanth_Vinay]

Hi everyone, i need to print the city with maximum avg value. i tried applying max function on avg measure its showing me an error. can someone help on how to show to calculate and show the max avg value using DAX?. i added image of list of avg's of all cities below.

[tamerj1 · Accepted solution]

Hi @Hemanth_Vinay 

My understanding is that ultimately you want to compare the average of each city with maximum and minimum averages of all cities. In order to do that you want to add two measures to your matrix. One for minimum average and one for maximum average. The value of the maximum average for example will be the same for all rows. Same for minimum average. Then you can take the difference and maybe percentage. I hope I'm right. Then you can use

Maximum Average =
MAXX ( ALL ( Table[City] ), [Z-Avg air Quality] )

Minimum Average =

MINX ( ALL ( Table[City] ), [Z-Avg air Quality] )

[amitchandak]

@Hemanth_Vinay , assume you have measure = [Z-Avg Quality Index] or create and use a measure

calculate(MAxx(Values(Table[City]) , [Z-Avg Quality Index])

or

if this is a column -Z-Avg Quality Index

calculate(MAxx(Values(Table[City]) ,calculate(Average(Table [Z-Avg Quality Index])))

[Hemanth_Vinay]

Hi @amitchandak thanks for helping me out but by using dax function which you have provided, i could only calculate average of each city, but what i want show is a single value of which city has the lowest or highest average.