Showing results for 
Search instead for 
Did you mean: 
DeekshaUL Frequent Visitor
Frequent Visitor

how to have global variables in PowerBI



I need to pass filtered value from one table to another for calculation.


Please note that the two tables cannot be connected through relationship.


I think some thing like Global variable can help here.


Please suggest.




Community Support Team
Community Support Team

Re: how to have global variables in PowerBI

@DeekshaUL ,


Do you mean to define a "Global varible" in dax formula which can be refered by each table? If that's what you mean, I'm afraid currently dax doesn't have such feature, the variable can only be used in the same dax formula.



Jimmy Tao

DouweMeer Member

Re: how to have global variables in PowerBI

Hello @DeekshaUL 

Global variable sounds like a IT slang. Can you put it in dummy language?

Is this something like an FX rate variable? 

siddheshmane Visitor

Re: how to have global variables in PowerBI

Hi @DeekshaUL ,


Have you tried creating measure that just stores the variable value. and then refer the measure in your second table.  Let me know if this works for you.



Siddhesh H Mane.

Helpful resources

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 346 members 3,450 guests
Please welcome our newest community members: