Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Junato47
Helper I
Helper I

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 the Risk appetite is "Averse" and the corresponding risk rating is "Very Low" or 2. if the Risk Appetite is "Minimal" and its corresponding Risk rating is "Low" or 3. if the Risk Appetite is "Conservative" and its corresponding Risk Rating is "Medium" or 4.if the Risk Appetite is "Flexible" and its corresponding Risk Rating is "High" or 5.if the Risk Appetite is "Aggresive" and its corresponding Risk Rating is " Very High". The Risk Rating is obtained from the table "Risk register New" and column name is "Residual Risk" and Risk appetite is obtained from the table "Risk register New" and column name is "Risk Appetite"

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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]

)

 

 

 

View solution in original post

3 REPLIES 3
v-jianboli-msft
Community Support
Community Support

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.

Anonymous
Not applicable

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]

)

 

 

 

Greg_Deckler
Super User
Super User

@Junato47 Probably a use case for SWITCH(TRUE(),...) but hard to say with the information provided. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.