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
CAGR = Var matrix1 =  CAGR (% TY v LLY)]
Var matrix2 =
    CALCULATE(CAGR (% TY v LLY)],
REMOVEFILTERS()
    )
Return
SWITCH( TRUE,matrix1 > matrix2, "GREEN", "RED")
Srikantht's avatar
Srikantht
Helper II
3 years ago

Hi Ahmedx 

 

Thank you for your quick response.

 

In the above you dax why you did not consider three tables of states, stores and product. ?

will removefilters appply to 3 tables whitout metioning in formaula. ?

 

Thanks