Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Aakash_Ladi
Regular Visitor

Can we have a common DAX expression which can be used in multiple measures

I have measures in which I am using DAX to filter two fact tables and then perform some aggregation. I have written the same filtering condition in almost 50 measures. Is it somehow possible that I can save these filtering conditions somewhere outside of measure(something like Global Variable)?

2 REPLIES 2
FreemanZ
Super User
Super User

This is a legitimate request, but there is no Global Variable in DAX. 

Do you think there is any workaround for this?

My measures are something like this:

abc = CALCULATE(SUM(column_nme),

FILTER(factTable1, pointDate >= factTable1[Date1] && pointDate <= factTable1[Date2]),

FILTER(factTable2, pointDate >= factTable2[Date1] && pointDate <= factTable2[Date2]),

TREATAS (values(Date1[col1]), factTable2[DateCol1]),

TREATAS (values(Date2[col2]), factTable1[DateCol1])

)

 

There are 40-50 such measures and users want to see at least 10 of them together. Now, When I am putting them together in a matrix visual, they are taking a long time to evaluate, 20 mins to be accurate. I think this is due to filtering two fact tables at once(both the fact tables are huge, 15 million rows in one and 5 million in another) and that too for every measure. Do you think there is any way that I can optimize the performance?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.