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?