Forum Discussion

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
4 years ago

DAX interpreter BUG!!!

The following (code in red) works when run in the Power Bi Desktop version, but as soon as you replace it by the variable name, which contains the same code, Power BI generates an error.  In a nutshe...
DAX BUG
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Element115 

Although variables can be used anywhere, however, their result might not be always the same. Because they are evaluated in the context in which they are written. 

Please refer to this thread for more details.

Caution When Using Variables in DAX and Power BI 

 

Best Regards,
Community Support Team _ Eason

 

 

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
4 years ago

TBH what you are saying makes no sense to me:  variables 

are evaluated in the context in which they are written.

 

Variables should be visible in the scope in which they are declared, period.  Are you saying that DAX scoping isn't following what we are used to with all major programming languages out there?  

 

In any case, all my variables are usually declared top level, ie right after the 'MeasureName = ' line.  Therefore I would expect this scope to be visible all the way down to the RETURN statement.

Isn't it so?