Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 ...
Need Help
  • manikumar34's avatar
    manikumar34
    1 year ago

    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
manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution Sage
1 year ago

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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you for your help .