Forum Discussion
Nested if for conditional colorig
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:
CALCULATE( IF(AVERAGE('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Current_Value])<
CALCULATE( IF(AVERAGE('alr ALR_PCI_SNIFFER_v2_DAILY_LOGS'[Current_Value])>
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.
3 Replies
Anonymous , First all this does not seem right to me
var rule_with_min = [UOM Type_measure] = "min"
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.
