topic Re: Can DAX variables declared in one measure be used other measures? in DAX Commands and Tips

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

Anonymous — Fri, 13 Aug 2021 11:36:34 GMT

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!

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

Mohammad_Refaei — Fri, 13 Aug 2021 13:54:01 GMT

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.

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

Anonymous — Fri, 13 Aug 2021 13:57:06 GMT

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!

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

Mohammad_Refaei — Fri, 13 Aug 2021 14:13:23 GMT

My pleasure