Forum Discussion
Solved
Conditionally Format Max Row Values and compare
Hey All. I have two tables, like below 1. 2. I am trying to conditionally color the values, if( the Items = Admin and Budgeted in Table 1) matches the (Item = Admin and baseline...
Hi bblackwell3
Adjust the measure "match or not":Match or not = IF(LOOKUPVALUE('Table2'[Budgeted],'Table2'[Budgeted],SELECTEDVALUE('Table1'[Budgeted])),"match","not match")color = VAR _max = CALCULATE(MAX('Table1'[Budgeted]),FILTER(ALL('Table1'),[Match or not] = "match")) RETURN SWITCH(TRUE(),SELECTEDVALUE('Table1'[Budgeted])=_max,"green")Result:
Pbix file attached.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This could be a possible solution. However, I made a mistake on my end. I actually do not have an Items column in Table 2. How would this alter the logic?
Hi bblackwell3
Adjust the measure "match or not":
Match or not = IF(LOOKUPVALUE('Table2'[Budgeted],'Table2'[Budgeted],SELECTEDVALUE('Table1'[Budgeted])),"match","not match")color =
VAR _max = CALCULATE(MAX('Table1'[Budgeted]),FILTER(ALL('Table1'),[Match or not] = "match"))
RETURN
SWITCH(TRUE(),SELECTEDVALUE('Table1'[Budgeted])=_max,"green")
Result:
Pbix file attached.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.