Forum Discussion
Optimizing measure
Hi I have made the following measure, used in a matrix, that gives me the correct data. But because of the massive amount of data in the dataset, it takes several minutes to display the data and...
mahoneypat
Microsoft Employee
Microsoft EmployeeI agree it is hard to suggest changes without seeing the expressions for the referenced measures. One thing you can do to narrow it down, is to put hard-code values in place for the measures and see which one(s) are causing the slowness. You can then maybe post that expression for advice on optimization (also share some details about your model (# rows and pic of relationships on tables used in the measure(s)).
You can also watch one of the SQLBI.com videos on optimizing measures.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat