cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mstone3
Helper II
Helper II

Can DAX variables declared in one measure be used other measures?

Hello,

 

I have declared several variables in a DAX measure that I would like to use in other measures, but it seems that variables only work within a measure and are not available for use in other measures.  Is this correct or is there a way to declare a global variable in DAX so that it's availble for use in any measure?

 

Thanks!

1 ACCEPTED SOLUTION
Mohammad_Refaei
Solution Specialist
Solution Specialist

Variables are measure specific, you have to define them every time in DAX.

You can just create a measure with the variable calculations and refer to it whenever needed, it will do the same job.

View solution in original post

3 REPLIES 3
Mohammad_Refaei
Solution Specialist
Solution Specialist

Variables are measure specific, you have to define them every time in DAX.

You can just create a measure with the variable calculations and refer to it whenever needed, it will do the same job.

Ah yes thank you!  It didn't occur to me that a measure with the variable calculations can serve as a global variable.  Thanks again!

My pleasure

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors