Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to assign a value to a variable based on multiple conditions

Hello, 

currently I have this DAX in my power BI: 

Priority = IF(Results[Business Impact]> [#Average_B] && [Reliability Score]<[#Average_R], "High","Low")
 
Now I need to add two more conditions:
1) If Results[Business Impact]> [#Average_B] && [Reliability Score]>[#Average_R], then Priority = Medium;
2) If Results[Business Impact]< [#Average_B] && [Reliability Score]<[#Average_R], then Priority = Medium
 
how to do that?
Thanks
 
 
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Please try something like the below.

    I am not sure which ones are measures and which ones are columns, but you can understand when you start writing the Switch function in your pbix file something like below.

     

    Priority =

    Switch (true(),

     

    Results[Business Impact]> [#Average_B] && Results [Reliability Score]<[#Average_R], "High",

    Results[Business Impact]> [#Average_B] && Results [Reliability Score]>[#Average_R], “Medium”,

    Results[Business Impact]< [#Average_B] && Results [Reliability Score]<[#Average_R], “Medium”,

     

    "Low" )

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, Anonymous 

    Please try something like the below.

    I am not sure which ones are measures and which ones are columns, but you can understand when you start writing the Switch function in your pbix file something like below.

     

    Priority =

    Switch (true(),

     

    Results[Business Impact]> [#Average_B] && Results [Reliability Score]<[#Average_R], "High",

    Results[Business Impact]> [#Average_B] && Results [Reliability Score]>[#Average_R], “Medium”,

    Results[Business Impact]< [#Average_B] && Results [Reliability Score]<[#Average_R], “Medium”,

     

    "Low" )

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Jihwan,

    First of all, thank you for your time, I believe the logic of your solution is correct, but the result didn't come right. 

    I notice the measure "#Average_B" which is like this "". I meant to calculate the average businessImpact (a series of numbers) of the entire table, but in this particular visual, for some reason, it is only calculated for each row. what did I do wrong?

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      5 years ago

      Hi, Anonymous 

      I am not sure how to step further.

      If it is OK with you, please share your sample pbix file, then I can try to look into it to come up with a more accurate measure.

      Thank you.