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
Hi,
I would like to color the card with the color
And the rule of color is:
The card is orange because the value USED or FREE of the following name (Name 1,Name 5, Name 7, Name 8 ) > 90 AND <=95
- 85 <MAX (USED or FREE) < = 90 THEN yellow
- 90< MAX(USED or FREE) <= 95 THEN orange
- MAX(USED or FREE) > 95 THEN red
Thank you
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"))
RETURN
val
Thank you for your help .