Forum Discussion

Srikantht's avatar
Srikantht
Icon for Helper II rankHelper 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
Icon for Super User rankSuper User
3 years ago

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

Srikantht's avatar
Srikantht
Icon for Helper II rankHelper 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.