Forum Discussion

mdaamirkhan's avatar
mdaamirkhan
Post Prodigy
3 years ago

How optimize KPI Color dax

HI All,

I wrote below two dax to highlight <0 red but it slow down the report. Can you help me how to optimized the dax to make it faster

 

1. KPI Color QV =

IF(If(max('wt_fin_staging pl_sorting'[Account_Type])=1 , _Measures[_Reporting Cycle_Q] - [_Vs Reporting Cycle_Q],  [_Vs Reporting Cycle_Q] -_Measures[_Reporting Cycle_Q])<0,0,1)

to highlight <-100% and <0
2. KPI Color QV% =

IF(_Measures[_Variance %_Q] = "<-100%" || _Measures[_Variance %_Q] < 0,0,1)


Thanks
Aamir


General Comment
Interesting Links
Need Help
Show and Tell

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    3 years ago

    mdaamirkhan 

    I trying understand the logic that you are trying to apply in these measures, please provide more details and share a dummy file with the scenario