Forum Discussion
Conditionally Format Max Row Values and compare
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.
Hi bblackwell3
First, create a measure to determine if the items and budgeted in the two tables match:
Match or not = IF(LOOKUPVALUE('Table2'[Budgeted],'Table2'[Items],SELECTEDVALUE('Table1'[Items]),'Table2'[Budgeted],SELECTEDVALUE('Table1'[Budgeted])),"match","not match")
Then create a measure to apply conditional formatting to the filtered matching values
color =
VAR _max = CALCULATE(MAX('Table1'[Budgeted]),FILTER(ALL('Table1'),[Match or not] = "match"))
RETURN
SWITCH(TRUE(),SELECTEDVALUE('Table1'[Budgeted])=_max,"green")
Result:
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.
