Can I create an expression measure using another expression measure within it?
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.
There are various reasons for the newly created measure not to be applicable while publishing a KPI. Possible reasons are as follows: Measure is not created/defined properly. The character type is incorrect. If an expression measure is not applicable ...
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 ...
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.
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.