Nested if for conditional colorig

[Anonymous]

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.

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

According to the formula you provided, if you want to use a judgment condition like [UOM Type_measure] = "min" in the filter condition, you need to rewrite it by the all function.

I did a test reference as follows:

M = 
VAR a = [M_min] = "min"
RETURN
    CALCULATE ( MAX ( 'Table'[Column1] ), FILTER(ALL('Table'),a))

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I want to say if that measure/column value is equal to "min" then name that as var rule_with_min .

[amitchandak]

@Anonymous , First all this does not seem right to me

var rule_with_min = [UOM Type_measure] = "min"