Why is the data displayed on Expression Measure, inconsistent?

• Related Articles

• 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.

• 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.

• Can an Expression Measure be added to a Computed Measure?

  As per product functionality, you cannot add expression measures into a computed measure since computed measure are generated run time & being created by ARC once data has been fetched from database.

• Where do we use an Expression Measure?

  Expression measure can be used where a conditional statement (for example, IF-THEN-ELSE) is necessary. You can use a base measure or a computed measure within an expression measure. An expression measure cannot be used within an expression measure.

• Can I create an expression measure using another expression measure within it?

  As per the functionality, an expression measure cannot be used within another expression measure. We can use only base measures within an expression measure.