How to use same string value in nested if conditions
Hi, Could someone please help on this. Below is the nested if condition I wrote. It is simple nested it formula and the logic behind it is also simple. Recurring GS + Price Col = IF('Table'[Account Description]="Recurring Gross Sales" || 'Table'[Account Description]="Recurring Price", "Recurring Gross Sales + Price", IF('Table'[Account Description]="Recurring Gross Sales" || 'Table'[Account Description]="Recurring Price" || 'Table'[Account Description]="Recurring Cancel" || 'Table'[Account Description]="Recurring Migrations" || 'Table'[Account Description]="Recurring Backlog Migrations", "Net Sales", BLANK())) Below is the output when using the above formula But, the expected output for Net Sales is below Any help on this please!
Nested if for conditional coloring
Dear Community, I m trying to write a measure that will later be used to color the matrix cell elements with conditional coloring. I have min and max in my data and depending on it the rule is like versa versa. The problem is that the second part of the measure works, when the fileds is not equal to min. While the first part of tthe measure when the field i equal to min, doesn't work. Here is my measure: Card color3 = var rule_with_min = [UOM Type_measure] = "min" var color_min = CALCULATE( IF(AVERAGE('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Current_Value])< MAX('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Threshold]) && rule_with_min, 1, IF(AVERAGE('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Current_Value])> MAX('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Threshold]) && rule_with_min, 0, 2))) var remaining_color = CALCULATE( IF(AVERAGE('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Current_Value])> MAX('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Threshold]), IF([UOM Type_measure] <> "min", 1, IF(AVERAGE('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Current_Value])< MAX('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Threshold]), IF([UOM Type_measure] <> "min", 0, IF([UOM Type_measure] <> "min", 2)))))) Return IF(rule_with_min, color_min, remaining_color) I would appreciate t highly if you could help me tackle this issue.
