Forum Discussion
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...
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]
)
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]
)