Forum Discussion

nimp_kp's avatar
nimp_kp
Frequent Visitor
6 years ago

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...
DAX
if statement
Measures
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Use DAX Studio to examine the query plan. That will help you decide what to change and how. You have lots of sub-measure black boxes.

 

You want to minimize the number of records looped, and maximize the SE/FE ratio.