Forum Discussion

Junato47's avatar
Junato47
Helper I
3 years ago
Solved

Dax Formula

How to use the Dax formula or any other method to create a new column to identify risks that meet its appetite. The condition for us to understand whether the risk is meeting its appetite is, 1. If t...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hello you can try :

     

    Measure =

    switch(

    selectedvalue(table[risk appetite]),

    "Averse",[very low calc],

    "Minimal",[low calc],

    "Conservative",[Medium calc],

    "Flexible",[high calc],

    "Agressive",[very high calc]

    )

     

     

     

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Junato47 ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

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