Trying to format individual values in a matrix table

[HDD328]

I've got a matrix table with actual values in it. I am trying to format each individual value based on targets from a seperate table. this is the mesure i've made to format this.

OilLightsFormatting = IF( SUM(LossByCodeActual[Values]) > SUM(LossByCodeTargets[Values]), "Red", "Green")

i've used similar in the past with no issues. this time though, it only makes the values in the matrix all the same color. this is a sample of what my tables look like. 

I dont believe it's a relationship issue. both tables are formatted the same and have the same code column. many to many relationship. any ideas what i'm doing wrong or how to get this formatting to work? thanks

[Anonymous · Accepted solution]

Hi @HDD328 

For your question, here is the method I provided:

Here's some dummy data

“LossByCodeActual”

“LossByCodeTargets”

Create a measure.

OilLightsFormatting = 
var _code = SELECTEDVALUE('LossByCodeActual'[Loss By Code])
RETURN
IF(
    SUM('LossByCodeActual'[Values]) > 
    LOOKUPVALUE('LossByCodeTargets'[Values], 'LossByCodeTargets'[Loss By Code], _code), 
    "Red", 
    "Green"
)

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[elitesmitpatel]

please share the dummy data and sample output images