Forum Discussion
Color the measure with condition
Hi, I have 2 tables : Name Name Model Type Name 1 Mono LR Name 2 Mono FA Name 3 Mono LR Name 4 Mono FA Name 5 Mono LR Name 6 Mono FA Name 7 Mono LR ...
Anonymous ,
Understood, use the below measure to do that.color1 =VAr val=CALCULATE(MAX(MAX(Number[USED]),MAX(Number[FREE])),'Name'[Model] = "Mono" && ('Name'[Type] = "WI" || 'Name'[Type] = "LR"))RETURNval
vojtechsima
Super User
Super UserAnonymous
try something simialr to this (create measure for USED/FREE or use MAX etc, depends how yo will display in visual):
SWITCH(TRUE(),
[USED] || [FREE] > 85, "yellow",
[USED] || [FREE] > 90, "orange",
[USED] || [FREE] > 95, "red"
)
Hi, I have justed added some more info, hope you could help. Thank you.