topic Multiple Column, multiple IFS and multiple Returns in DAX Commands and Tips

Multiple Column, multiple IFS and multiple Returns

Anonymous — Mon, 23 Jan 2023 13:45:53 GMT

Hello All,

I'm am trying to return a text based off of IFS in two columns. I'm not sure how I go about it. The "Score Rank" column was fairly easy to do, but I'm not sure about adding another column to the equasion.

Thank you.

Re: Multiple Column, multiple IFS and multiple Returns

amitchandak — Mon, 23 Jan 2023 13:52:08 GMT

Anonymous , What is logic use

One is

Switch( True() ,

[Rank] <= 5, "Low",

[Rank] <= 10, "Med",

"High"

)

Re: Multiple Column, multiple IFS and multiple Returns

FreemanZ — Mon, 23 Jan 2023 13:54:04 GMT

hi Anonymous

try like:

Column =
IF(
[Type]="Issue",
[Type],
[Score Rank]
)

Re: Multiple Column, multiple IFS and multiple Returns

Anonymous — Mon, 23 Jan 2023 14:07:58 GMT

Thank you for the quick response, but I'm not sure if I'm understanding.

This is how I created the Score Rank column:

Score_Rank = IF(AND([Risk score]>=0, [Risk score]<8),"low",

IF(AND([Risk score]>=8, [Risk score]<15),"medium",

IF(AND([Risk score]>=15, [Risk score]<30),"high")))

The "score_rank" column I'm trying to populate has to have that, but if "issue" is in the Type column, then I need to return "Issue" instead of low, medium, or high.

Thank again,

Mike

Re: Multiple Column, multiple IFS and multiple Returns

FreemanZ — Mon, 23 Jan 2023 15:42:54 GMT

hi Anonymous

this info is critical, try this:

Score_Rank = SWITCH( TRUE(), [Type]="Issue", [Type], [Probability]<8, "low", [Probability]<15, "medium", "high" )

Re: Multiple Column, multiple IFS and multiple Returns

Anonymous — Mon, 23 Jan 2023 16:39:39 GMT

Thank you. That's got me about 90% there.

I should have been more specific with calculation explanation. If the type is "Issue", then the only value it can return is "Issue" For "Risk", it follows the below criteria:

Low = 0-8

Med = 9-14

High = 14+

Mike

The formula is returning incorrect values for the Score_Rank column.

Example of what's its returning:

Type Prob Score Rank Score_Rank

Risk 9 Medium Low

Risk 5