Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)?
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |