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]

    )

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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.