Different contional formatting for total

[MCacc]

Hello, 

I have a request from my customer where the target value with which I do my conditional formatting in a column in my matrix visual is different from the total in comparison to the value.

As you can see, my total has a target value (90%) different from the rest of the table.

The Measure I use for my %
MY DAX MEASURE FOR % = DIVIDE(SUM(TABLE[COUNT ERRORS]),SUM(TABLE[COUNT INSERTS]),0)

The measure I use for my field condtional formatting
MEASURE FOR FORMATTING = IF([MY DAX MEASURE FOR %] < 0,95,1, 0)

Then in the condtional formatting I apply the rule as follows --> MEASURE FOR FORMATTING = 1, "green", 0 = "red"

Any idea how in my measure I can use the value 0,90 (90%) to apply a specific condtional formatting for my total?

Thank you. 

[amitchandak]

@MCacc , Return color and use in conditional formatting using the field value option

MEASURE FOR FORMATTING =
if( isinscope(Table[Column]) ,
if([MY DAX MEASURE FOR %] < 0.95,"Red", "Green") ,
if([MY DAX MEASURE FOR %] < 0.90,"Red", "Green")
)

The column is not summarized (Aggregated column)

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...