Hi,
I would like to have a calculated measure e.g. "KPI" which acts as a container of different measures. User interaction will define which of mentioned measures should be shown in a chart.
a script variable type string has been created and the condition to choose the right measure is already working. What is missing: how to expose the script variable in order to define KPI = script variable?
I need this calculated measure to be able to change variance measures as up to now there is no api for variances.
This is an example where a script variable can be used within a calculated measure. However I could not call the variable directly and that is why I think I need a calc. measure and 'fill' it with the measure id from the variable.
thank you in advance for any recommendations
regards
Edgar