How to culculate "Average" of rows?

Questions & Answers
2

Hi @popovsa88

When you add the Add calculated → Statistical → Average column, you can click on the column header and choose the “Edit calculated” option to see and copy the formula used in this calculation.

It should look something like this:

CASE WHEN NOT IsEmpty([Measures].[Diff%]) THEN
  ConstantColumnValue(CatchException(
    Avg(VisibleRowsSet(), [Measures].[Diff%])
  ))
END

Now, edit the formula of your “Diff%” measure to override the calculation of the Total row:

CASE WHEN
[Team].CurrentMember.Name="$total_aggregate"
THEN
ConstantColumnValue(CatchException(
    Avg(VisibleRowsSet(), [Measures].[Diff%])
))
ELSE
-- your Diff% formula goes here
END

Let me know if this fits your use case!
Best regards,
Nauris / eazyBI support