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
danextian
Super User
Super UserHi Anonymous
Try this:
color =
VAR _used =
CALCULATE (
SELECTEDVALUE ( Number[USED] ),
USERELATIONSHIP ( 'Name'[Name], 'Name'[Name] )
)
VAR _free =
CALCULATE (
SELECTEDVALUE ( Number[FREE] ),
USERELATIONSHIP ( 'Name'[Name], 'Name'[Name] )
)
VAR _max =
MAX ( _used, _free )
RETURN
SWITCH ( TRUE (), _max > 95, "red", _max > 90, "orange", _max > 85, "yellow" )
Hi, sorry I didn't give enough info in the first post, I have added some more info. thank you for your help