Forum Discussion
DAX query optimization
Hi everyone, so I have this measure that calculates overdue jobs. I wanted to optimize it as when I have filter dates (year & months), it throws an error. Thanks in advance 🙂 Overdu...
Change USERELATIONSHIP to TREATAS
Rewrite the FILTER part - it doesn't have to be that complicated inside a CALCULATE
Rearrange the filters in order of cardinality impact
In general you will want to install DAX Studio and then check the query plan that is generated by the measure. That will help you to identify which part needs tuning.