Apply background colour to card using single Measure

[Sharmi_28]

I have table with 7 columns

I am using New card visual

I want to apply background colour using single Measure
If SUM(Table[1]) > 1 , "Green", "Red"
If SUM(Table[2]) > 1 , "Green", "Red"
If SUM(Table[3]) > 1 , "Green", "Red"
If SUM(Table[4]) > 1 , "Green", "Red"
If SUM(Table[5]) > 1 , "Green", "Red"
If SUM(Table[6]) > 1 , "Green", "Red"
If SUM(Table[7]) > 1 , "Green", "Red"

[Alex87 · Accepted solution]

yes, CF on background using only one measure as in your request:

CF_Background = 
SWITCH(
    TRUE(),
    SUM(Test[Value]) > 1, "Green",
    "Red"
)

I did change the structure in Power Query as well, though, I unpivoted the data 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjVR0lEyNQMSBkBsZg5imZlCuUDJ2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"1" = _t, #"2" = _t, #"3" = _t, #"4" = _t, #"5" = _t, #"6" = _t, #"7" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"1", Int64.Type}, {"2", Int64.Type}, {"3", Int64.Type}, {"4", Int64.Type}, {"5", Int64.Type}, {"6", Int64.Type}, {"7", Int64.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value")
in
    #"Unpivoted Columns"

so that it looks like this:

I then used the Matric visual, swithched in the option pane the values to rows, applied the CF on text and background

[Sharmi_28]

@Alex87Thanks a lot

[Sharmi_28]

@Alex87 
Thanks you.
Did you apply background colour using measure?

[Alex87]

the closest I can get is using a matrix.