cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
mussol_
Advocate II
Advocate II

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.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

You can create a measure that contains the variable that you want and then, reuse your measure (that will be same a your variable).

 

 

mussol_
Advocate II
Advocate II

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.

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

As far as I know, you can't use a variable declared within a measure with VAR anywhere else. If you need to reuse that data, consider making that variable into a standalone measure.

 

Although, I would be curious if it's possible to implement similar behavior as to what happens when you use a dot operator after a date.

 

image.png

Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors