Calculate Average with removed outliers

Questions & Answers
1

Hi all,

i have a list of tools and have their mean time between failure in a table.
Therer are items added to the list or removed manually (no automatic filter)
From this list i need the Avg and the Average with outliers removed.

The formular would be:

Calculate Min of the list
Calculate Max of the list

(Sum of whole list - Max - Min ) ( Rows count -2)

image

2

Hi,

The recommended approach for the calculation of the average of all rows is to use the standard calculation:

image
image1492×1056 109 KB

This option creates one more column of the average. The good thing is that it automatically adjusts if you manually remove members.

We can find the code behind this calculation and reuse the formula to make one more measure without the min and max values:

image
image1198×454 45.6 KB

The following adjustment will eliminate the rows where the measure is equal to the highest or lowest value:

Avg(
Filter(
  VisibleRowsSet(),
  [Measures].[Mean time between failure]<>
  Max(VisibleRowsSet(),[Measures].[Mean time between failure])
  AND
  [Measures].[Mean time between failure]<>
  MIn(VisibleRowsSet(),[Measures].[Mean time between failure])
),
[Measures].[Mean time between failure]
)

image
image1202×1188 107 KB

Kindly,
Janis, eazyBI support

3

Thank you so much for your help!!!
It works perfectly.