Help with optimizing DAX query

HI Anonymous,

I found you are lots of iterators calculation functions in your formulas, if your table contains huge amount of records, it obviously will cause the performance issue.

In addition, when you combo use if statement and iterators functions will increase looping amount.(e.g COST_CUM measure. iterator functions will loop all rows in expression table. It means functions will loop multiple times when you use it in if statement: row count which suitable for the conditionals * dimdate table row count)

Reference links:

Optimizing nested iterators in DAX

Optimizing DAX with cardinality estimation: computing working days

Regards,

Xiaoxin Sheng