Filter rows bigger than average

Hello everyone,

I have a project where the issue type is marked with the field component and want to show only those issues that the time spent in all columns is bigger than the average of the component.

I found the way to show the issues by component and the time spent in all columns but I am not able to show only the issues over the average.


Try creating a new calcualted measure using this formula

[Measures].[System Lead Time]>=
  [Measures].[System Lead Time],
[Measures].[Issues created],

Then select this measure in your report.
Next, filter the report by this column > click and choose filter using “bigger than” filter (and type > 0)
Finally, it is safe to remove the last measure from the report columns.

Martins / eazyBI support