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
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
6 years ago

Hey Anonymous ,

please provide more information what you exactly want to happen, and how the values from your table should be formatted based on what condition.

There are three states, less than, equal to, or greater than.

 

Another question, is there an existing relationship between both tables in your data model?

 

Regards,

Tom