Forum Discussion
Add conditional column using mesure to pic specific value and create new colum
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!
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.
5 Replies
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"
)
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"
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.
hi Anonymous
Try:
yourMeasure = IF( CONTAINSSTRING( 'yourTable'[Pass/Fail], "Errors" ), "Fail" , "In Progress" )
