Forum Discussion

sivarajan21's avatar
sivarajan21
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Dax referenced measures causes performance issues

Hi Team,   I have created a dax measure as below:   VT_Targetunitrate_2 = SUMX ( Accruals, IF ( [Accrual cost source_2] = "Target", [Switch Cost] ) )   I also tried using calculate but i am no...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • marcorusso's avatar
    marcorusso
    1 year ago

    Unfortunately, I don't have time to investigate more on your report. 

    In general, you could try to rewrite the code without using measure references - it's not the best way, but it is the quickest way to think about how to rewrite the code in a more efficient way. If you are forced to repeat the calculation, probably/hopefully you will find a natural way to write the expression in a simpler way.

marcorusso's avatar
marcorusso
Icon for Most Valuable Professional rankMost Valuable Professional
1 year ago

Unfortunately, I don't have time to investigate more on your report. 

In general, you could try to rewrite the code without using measure references - it's not the best way, but it is the quickest way to think about how to rewrite the code in a more efficient way. If you are forced to repeat the calculation, probably/hopefully you will find a natural way to write the expression in a simpler way.

sivarajan21's avatar
sivarajan21
Icon for Post Prodigy rankPost Prodigy
1 year ago

Thanks for your response marcorusso !

For now i will accept it as solution & work on it!