How optimize KPI Color dax

[mdaamirkhan]

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

[mdaamirkhan]

any update

[Fowmy]

@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