Creating a measure for an adjusted mean

[jenhross]

I need to create a measure that is an adjusted average and always eliminates the maximum cost in a data set.  Then using that measure, I need to create a target range.  How can I write this adjusted average in M and will I need to do anything to the range figures or is that all fine, since those will always be adjusted according to the new adjusted average?

[amitchandak]

@jenhross , Try a measure like

adjusted mean = averageX(Table, if([cost]<max(Table[Cost]),[cost],blank()))

else create a new column
max cost = max(Table[Cost])
then a new measure
adjusted mean = averageX(Table, if([cost]<[Max Cost],[cost],blank()))