Hello everybody, i want to use the value of an expression in a set expression.
For e.g. my expression ist -->
if((only({<Jahr={"$(=max(Jahr))"}>}[AuslaufFlag])=1 and only({<Jahr={"$(=max(Jahr)-1)"}>}[AuslaufFlag])=0) or (only({<Jahr={"$(=max(Jahr))"}>}[AuslaufFlag])=1 and len(only({<Jahr={"$(=max(Jahr)-1)"}>}[AuslaufFlag]))=0),'Zugang',Null())
and now want to use the value "Zugang" for a set expression
like sum({$<Zugang={'Zugang'}>}[Bilanzwert zu EK])
i suggest try the following: 1. clear all filters (create a current selection object to make sure nothing is selected) 2. create a list for the field Zugang, then select the value 'Zugang' 3. create a text box with the expression sum([Bilanzwert zu EK])
the text object should have the same value as sum({$<Zugang={'Zugang'}>}[Bilanzwert zu EK])
then re-create the scenario where you arent getting the expected value. check the selections (what filters you have) and go from there - you can try clear filters one by one
I assume it would be rather not possible because you would need to embed it within a $-sign expansion which operate only on a global level. Another possibility might be to use this within any aggr() constructs but I think it makes everything more complicated as it would be helpful. Therefore I suggest a small change to your approach and using it as a flag-calculation (maybe within a variable) like:
var: if((only({<Jahr={"$(=max(Jahr))"}>}[AuslaufFlag])=1 and only({<Jahr={"$(=max(Jahr)-1)"}>}[AuslaufFlag])=0) or (only({<Jahr={"$(=max(Jahr))"}>}[AuslaufFlag])=1 and len(only({<Jahr={"$(=max(Jahr)-1)"}>}[AuslaufFlag]))=0),1,0)
