Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional formatting based on other column

I have a utilization table and I have to conditionally format each value based on the following matrix Title  Target Utlization Principal  50% Director 50% Manager 50% Consultant ...
Need Help
  • rubinboer's avatar
    rubinboer
    6 years ago

    i agree more info is needed so i will make a few assumptions.

    the two tables are linked by title and the title in the target table is unique.

     

    creat a check to see if the utilization achieves the target,

    Target Check =
    VAR Target = LOOKUPVALUE('Tab A'[Target Utlization],'Tab A'[Title ],CALCULATE(MINX('Tab B','Tab B'[Title])))
    VAR Base = SUMX('Tab B',[Utilization %])
    return (Base - Target)
    if his is negative you didntmake target if positive you made it
     
    now create a conditional format rule on the table you wish to check, based on the Target check.
     
    model
     
    result
rubinboer's avatar
rubinboer
Resolver II
6 years ago

i agree more info is needed so i will make a few assumptions.

the two tables are linked by title and the title in the target table is unique.

 

creat a check to see if the utilization achieves the target,

Target Check =
VAR Target = LOOKUPVALUE('Tab A'[Target Utlization],'Tab A'[Title ],CALCULATE(MINX('Tab B','Tab B'[Title])))
VAR Base = SUMX('Tab B',[Utilization %])
return (Base - Target)
if his is negative you didntmake target if positive you made it
 
now create a conditional format rule on the table you wish to check, based on the Target check.
 
model
 
result