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 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.
 
DAX
Nested IF

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
    Appreciate your Kudos.



  • 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.