Using Conditional Formatting to show 10% above and 10% below Group%

[jonnyA]

Using Conditional Formatting how could I highlight the "Provider %" which is 10% above the "Group %"

Using Conditional Formatting how could I highlight the "Provider %" which is 10% below the "Group %"

Thank you in advance!

[amitchandak]

@jonnyA , Create a color measure and use that in conditional formatting using filed value option

Switch(True(),

[Provider %]> [Group %] *1.1 , "Green" ,
[Provider %]< [Group %] *.9 , "Red" ,
"Blue"

)

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[jonnyA]

When I try this formula all the data that was in the matrix goes away when adding the formula you said to try.

Color 3 = Switch(True(),

[Provider %]> [Group Average (Ignore Degree)] *1.1 , "Green" ,

[Provider %]< [Group Average (Ignore Degree)] *.9 , "Red" ,

"Blue"

)

[jonnyA]

How do i fix this measure witht the data i have?  I couldnt get the formula you sent me to work.

[aj1973]

[Provider %] is not a measure in your model you need to create it

[jonnyA]

Provider % = CPT Code; shown as "Count" with show valaue as "% of row total"

[aj1973]

I know, that's why you need a measure like 

Provider % = COUNT( 'Table'[CPT Code])