Where do we use an Expression measure? Explain its functionality

• Related Articles

• 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 we use computed measures in an expression measure?

  Computed measures cannot be used in an Expression measure.

• Can I use a temporary measure in Expression Measure to publish KPI?

  No, you cannot. You can use only the permanent 'base measures' in ARC.

• Can I use a temporary measure in the expression measure and publish the KPI?

  No. As per the functionality, you can use only the base measures which are saved as 'permanent' in ARC.

• Why do I get the error 'Measure not applicable', when I use the created expression measure in KPI?

  The reasons could be any of the following: Measure ID is not prefixed with Table Name. Expression is not correct. This error can also occur in newly created measures due to the following reasons: Measure is not created/defined properly. The character ...