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

Ahmedx 

 

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

 

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