If formula / Conditional formatting with 0% and NA's

[Undercoverstig]

Hi All

Could someone help with possibly an IF fromula please. Basically I needed to add an +0 to my formula as Team E should show 0% in that they had activity but did not meet the timely criteria.

However Team C have not have any activity and with conditional formatting (<70%) thier cell highlights green as assuming it is because of no return. 

What would I need to add to my formula either to mark Team C's row as NA? and for the Conditional Formatting to not apply. 

Events Logged  = DIVIDE(

CALCULATE(COUNTA('Actvity logged'[Days between]),'Actvity logged'[Days between]<=30)+0,

CALCULATE(COUNTA('Actvity logged'[Days between]),'Actvity logged'[Days between ]>=0))

 

[Anonymous · Accepted solution]

Hi @Undercoverstig ,

According to your description, here are my steps you can follow as a solution.

(1) We can create measures.

na%Timely = IF(MAX('Table'[Activity Logged]) ==BLANK(),"NA",'Table'[%Timely])

Measure = SWITCH(TRUE(),[na%Timely]="NA","WHITE",[na%Timely]+0<0.7,"GREEN")

(2)Set conditional formatting.

(3) Then the result is as follows.

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution  to help the other members find it more quickly.