While adding a base measure with average aggregation then, the total field should show the average value, but it shows the sum of that average. Why?

• Related Articles

• When I add a base measure with average aggregation, the Total field should show the average value. But why is it showing the sum of that average?

  The sum of the average is displayed in the 'Total' field becauase the functionality is to display the total value and not the average value. When you add a base measure with average aggregation, it considers only the line items and not the 'Total' ...

• Expression measure created shows the sum of all data displayed. It is expected to show based on the expression specified

  The Total row of an expression measure will provide the summation of all the rows whereas, computed measure will provide results based on the formula specified. This is the standard ARC functionality.

• Linked dimension is not working, while adding a measure to the KPI. It shows the error 'Suitable dimension is not available for the selected measure." Why?

  Ensure that the details (example, table names, column names etc) defined in the 'dbmodel.xml' file matches with those in the database. For example, if a table name for a dimension in the database is in UPPERCASE, the dimension name defined in ...

• Does the Expression Measure display the sum of all the data or data based on the expression specified?

  Expression Measure displays the sum of all the data. The Total Row of an Expression Measure displays the sum of all the rows. The Computed Measure for a KPI displays the data based on the expression specified. This is a standard ARC functionality.

• A base measure added in one view is not visible in another view.

  The measure added for a particular view is valid only for that view and will not be visible under any other view. It is the functionality of ARC