Conditional Format a matrix table: Measure and Column

[Anonymous]

Hi Team,

I have a matrix table as displayed below. 

The Performance Column is a measure and the Target column is a column from the raw data.

When the Performance > Target I want the background to be red.

When the Performance < Target I want the background to be green. 

Could anyone please help me out?

Thank you

	Measure	Column
Year	Performance	Target
2015	11	10
2016	8	9
2017	6	8
2018	4	7
2019	3	6

[Anonymous · Accepted solution]

@TomMartens solved the issue in another post.

Conditional_Value = If(HASONEVALUE('Table A'[NAME]),
IF(
    [Current_Value]>SUM('Table B'[HI HI (red)])
    , "#FF0000"
    , "#008000"
)
)

Thanks Tom!