Forum Discussion

Srikantht's avatar
Srikantht
Helper II
3 years ago

Optimize my dax query

Hi,   Can anyone optimize the below query. it's taking 15 seconds to load when I run in Dax studio. and this measure I am using for conditional formatting.  CAGR = Var matrix1 =  CAGR (% TY v LLY)...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

Didn't understand! has your question been optimized or not?

  • Srikantht's avatar
    Srikantht
    Helper II
    3 years ago

    Ahmedx 

     

    your measure not worked it gives "RED" for every category. 

     

    my question in your measure, why you did not take three tables? 

  • Srikantht's avatar
    Srikantht
    Helper II
    3 years ago

    Hi 

     

    Anyone have idea to optimize this measure?

     

    and also I 've created this measure in report level. and data is coming from SSAS model. if i create same measue in ssas model and deploy then add to report. will it be optimse? becuase this measure comes from then SSAS model. 

     

     

    anyone help me in this?

     

    Thanks.