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
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
    Icon for Helper II rankHelper 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