Forum Discussion

mussol_'s avatar
mussol_
Icon for Advocate II rankAdvocate II
8 years ago
Solved

reuse variables

Hi all! My question is very simple: Can I reuse variables I created in another mesure? If answer is "yes", how can I do this? Many thanks in advance! Josep.
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    No, you would want to create measures for each variable, then they are reuseable but variables within a measure only have local scope of the measure they are in.

mussol_'s avatar
mussol_
Icon for Advocate II rankAdvocate II
8 years ago

Both: thanks a lot.

It's a pity :-((

I think i would be useful once you already create the variable to use in another measure. Otherwise, it is necessary to create the same variables on each measure.

Josep.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Well, the idea is that if you are going to need to create the same variable in multiple measures, create the variable as a stand-alone measure. Then you can reuse it. So, if you have measures like:

 

Measure = 

VAR __myVar = COUNTROWS(SUMMARIZE('Table',[Column]))

RETURN __myVar * 20

 

Measure1 = 

VAR __myVar = COUNTROWS(SUMMARIZE('Table',[Column]))

RETURN __myVar / 20

 

Then you could create a measure like:

 

MeasureMyCount = COUNTROWS(SUMMARIZE('Table',[Column]))

 

Then your measures become:

 

Measure = [MeasureMyCount] * 20

Measure1 = [MeasureMyCount] / 20