Forum Discussion
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 | 88% |
| Senior Consultant | 88% |
And my table looks like this;
| Title | Utilization % |
| Consultant | 82.47% |
| Consultant | 82.10% |
| Director | 20.74% |
| Director | 19.31% |
| Manager | 32.86% |
| Manager | 28.05% |
| Principal | 61.64% |
| Principal | 29.62% |
| Senior Consultant | 38.65% |
| Senior Consultant | 37.50% |
Please help
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 itnow create a conditional format rule on the table you wish to check, based on the Target check.modelresult
2 Replies
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 itnow create a conditional format rule on the table you wish to check, based on the Target check.modelresultHey 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
