Dynamic Conditional Formatting of 3 table column values based on value of what if parameter value

[easton16]

I am trying to get 3 columns in a table (call it 'Table1' in this case) to dynamically conditional format based on 'what if value parameter seleceted' ('TemperatureFilter')

I can do this by creating a calculated column for each, but struggling with doing it as a measure so that it updates each time the parameter value is changed?

So with the sample below if a user selected 35 I want all of the values below 35 in each of the 3 column to be highlighted red.

Any pointers would be much appreciated.

[Anonymous]

I wonder what to do if we have 15 different columns(15 different measures) in a table visual that require conditional formatting with a same rule of values. Writing 15 measures for dynamic coloring is not wise. 

I don't think we can dymincally reference table visual column header and change feild used in measure. 

Hope I'm clear ! 

[easton16]

Thanks @Fowmy  I was overcomplicated it by thinking that SUM would add the column up and not apply it row by row, which of course is what it would do!

[Fowmy · Accepted solution]

@easton16 

Create three measures for each column and assign them as Field Value under conditional formating

Hope you have the simple measures created for each column and a parameter

Example: 

CF 20M = IF( [Sum of 20M] < [Parameter Value] , "red" )