Conditional formatting with icons not applying to Totals correctly

[Anonymous]

Hi there

Hoping someone can help with this. I have this table (not a matrix table) with the conditional format added: 

But when I go to add the traffic light to the Total row as well it turns all the icons (including the Total) to just red. 

The traffic light field is a simple DAX measure: Traffic lights = SUM(table[Column1)/ SUM(table[Column2).

Is anyone able to shed some light on why this might be happening? 

[Anonymous]

Hi @Anonymous ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

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

[amitchandak]

@Anonymous , as this is % column, Are you using .85 for 85% or 85 .

You should use .85 for 85 %. same is true for others.

else share conditions

[Anonymous]

Jut tried as suggested and it's the same story. All turn red.

Here's the conditions: 

[amitchandak · Accepted solution]

@Anonymous , In place of Percent use number and use  values like  .95 to 1

.7 to .95

0 . to .7