Forum Discussion
Optimize complex dax measure
Hello All, After going through all the possible ways of optimization of a measure which i have written, I am reaching out to you community members to help me out. below is dax query which i have...
Look at the query plan and find rows with excessive number of records. That's where the cartesians happen that you need to eliminate.
Break your measure down into smaller parts and evaluate these part by part to see where it becomes expensive.