color measure by field value matrix

[Anonymous]

Hi there, 

I'm trying to update my measure so the "university connection" values only show red for greater than 2, "street team" greater than 8, and "social media" greater than 12, etc.

[amitchandak · Accepted solution]

@Anonymous , Try A meausre like

Switch( True() ,

max(Table[Type)=  "university connection" && [Primary Zeros]> 2, "Red",

max(Table[Type)=  "street team" && [Primary Zeros]> 8, "Red",

max(Table[Type)=  "Social Media" && [Primary Zeros]> 12, "Red",

"White"

)

[Anonymous]

Ahhh! Thank you so very much!