Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
DAX
Nested IF
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Basically I have 2 cases:

1. if (average(curret_value) < threshold, then 1, 2)

2. if (average(curret_value) > threshold, then 1, 2)

I want to write these 2 conditions using  variable in DAX.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    My 2 conditions:

    1. if (average(curret_value) < threshold, then 1, 2)

    2. if (average(curret_value) > threshold, then 1, 2)

     

    So, if [UOM Type_measure] = "min", use condition 1, else use condition 2. Hope this makes my question more clear.