Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Am I able to reference my Section title within the script?
So I actually worked out a way to get around this.
Rather than use a Variable in my expression, i have used a StateName() and then created a statename for each of the options needed then assigned the state to the chart.
I am unsure of the impact it will have on the speed of the app as yet, but will report back if any issues arise.
The below is part of the expression I am using for reference:
Sum({1<[BU15]={"$(=Statename())"}>}[Sales Value] )
AFAIK no - but you could reference on already loaded tables/data and also use sub-routines and/or variables to avoid redundant stuff.
- Marcus
So I actually worked out a way to get around this.
Rather than use a Variable in my expression, i have used a StateName() and then created a statename for each of the options needed then assigned the state to the chart.
I am unsure of the impact it will have on the speed of the app as yet, but will report back if any issues arise.
The below is part of the expression I am using for reference:
Sum({1<[BU15]={"$(=Statename())"}>}[Sales Value] )