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 created the measure color of danextian but it doesn't work.
I would like to create a measure to color the card :
RESULT : 1/5
Name 3 / Name 1, Name 3, Name 5, Name 7, Name 8
| Name | USED | FREE |
| Name 1 | 80 | 86 |
| Name 3 | 55 | 55 |
| Name 5 | 50 | 95 |
| Name 7 | 50 | 95 |
| Name 8 | 50 | 95 |
There are 4 differences, IF one of these 4 Names having:
- 85 <MAX (USED or FREE) < = 90 THEN yellow
- 90< MAX(USED or FREE) <= 95 THEN orange
- MAX(USED or FREE) > 95 THEN red
In this case, the color of the measure should be orange (90< MAX(USED or FREE) <= 95)
Thank you
manikumar34
Solution Sage
Solution SageAnonymous ,
I can see it is working, could you please share what is your exact requirement?
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 redThank you- manikumar34
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"))RETURNvalThank you for your help .