Add conditional column using mesure to pic specific value and create new colum

[Anonymous]

I have created below table using mesure. All working as expected except the values in "Final Value" colum. The requirement is that if -

1. "Pass/Fail" column is = Ok than return "Pass"

2. "Pass/Fail" column is = Errors than return "Fail"

3. "Pass/Fail" column is = In Progress than return "In Progress" 

4. "Pass/Fail" column is = Initial than return "Not Started"

Else "In Process"

In the below example column value must be "In Process", the code that i have written on the screen for the colum "Filal Status" is incorrectly showing "Initila". Please help! 

[rubinboer]

hi @Anonymous 

Try:

yourMeasure = IF( CONTAINSSTRING( 'yourTable'[Pass/Fail], "Errors" ), "Fail" , "In Progress" )

[Anonymous]

Correction - 

If the "Pass/Fail" value contains "Fail" than it should returm "Fail". 

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.

Column = SWITCH(TRUE(),
SEARCH("OK",[Pass/Fail],,0)<>0,"Pass",
SEARCH("Fail",[Pass/Fail],,0)<>0,"Fail",
SEARCH("In Progress",[Pass/Fail],,0)<>0,"In Progress",
SEARCH("Initial",[Pass/Fail],,0)<>0,"Not Started",
"In Process")

SEARCH function (DAX) - DAX | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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

[rubinboer]

hi @Anonymous 

your evaluation is on a different column [MaxFlow], based on yyour requirement you need to evaluate the ["Pass/Fail"] Column.

your evaluation will be something else based on your data tho:

Switch ( 'yourcolumn'[Pass/Fail],

"OK" ,"Pass", 

"Errors", "Fail" ,

"In Progress", "In Progress",

"Initial ", "Not Started" ,

"In Process"

)

[Anonymous]

@rubinboer 

Thanks a lot for replying !

Your solution works, i have another requirement in addition to the one that you have givn to me. If the "Pass/Fail" value contains "Errors" than it should returm "Fail". 

For all other combinations\(as displayed on the screen below), it mest me "In Progress"