Forum Discussion
Measure taking forever to execute
Hello everyone I have a reacurring issue I have a measure which calculates the starting id (row number) and the ending id according to some conditions. These conditions change for every row. Aft...
Install DAX Studio and use it to display the query execution plan. Based on the output you can decide where to optimize your measure. Most likely the FIRSTNONBLANK() is the culprit, but DAX Studio will tell you exactly.
I know why it takes so long. It is the _nextId variable.
It is because I preform an expensive calculation for every row. The table in which I have to search for values has a little less then 500 000 rows... I don't know if there is a better method to do this