Forum Discussion
jonnyA
Responsive Resident
Responsive ResidentUsing Conditional Formatting to show 10% above and 10% below Group%
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 "Gr...
aj1973
Community Champion
Community Championwhat is the measure behind this column?
use one of these measure so I can see the outcome
jonnyAResponsive Resident
Responsive ResidentColor 2 = IF ( [Provider %] > 1.1 * [Group Average (Ignore Degree)] , "Green" , IF ( [Provider %] < 1.1 * [Group Average (Ignore Degree)] , "Red"))
Provider % = COUNT( 'Table_Charge_Dataset'[CPT_Code])
Group Average (Ignore Degree) = IF (
ISFILTERED (Table_Charge_Dataset[Provider_Degree]), CALCULATE([Group Average], REMOVEFILTERS(Table_Charge_Dataset[Provider_Degree])), [Group Average])
- jonnyA
Your previous comment is 3 formula's correct? I tried them, but cannot get to work.