https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-if-funciotn/m-p/2796174#M87867 <P>Thank you!</P> Mon, 26 Sep 2022 11:25:24 GMT FILIPKACZMAR 2022-09-26T11:25:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-if-funciotn/m-p/2796147#M87863 <P>Hello everyone!<BR /><BR />I want to make a checklist in my Power BI dashboard. I have got column called status in my data. I want to sort it in another column by "True" and "False".&nbsp;<BR />I wrote code:&nbsp;</P><DIV><DIV><SPAN>if</SPAN><SPAN> ( </SPAN><SPAN>'SQA list 2022'[Status]</SPAN><SPAN> = </SPAN><SPAN>"Completed, Waived, Cancelled, Missed"</SPAN><SPAN>, </SPAN><SPAN>True</SPAN><SPAN>(), F</SPAN><SPAN>alse</SPAN><SPAN>())<BR /></SPAN>But it is giving me back only False values.<BR /><BR />Can you help me? Thank you</DIV></DIV> Mon, 26 Sep 2022 11:09:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-if-funciotn/m-p/2796147#M87863 FILIPKACZMAR 2022-09-26T11:09:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-if-funciotn/m-p/2796164#M87866 <P>try</P> <LI-CODE lang="markup">'SQA list 2022'[Status] IN { "Completed", "Waived", "Cancelled", "Missed" }</LI-CODE> <P>that will return true if the status is one of those values, false otherwise</P> Mon, 26 Sep 2022 11:20:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-if-funciotn/m-p/2796164#M87866 johnt75 2022-09-26T11:20:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-if-funciotn/m-p/2796174#M87867 <P>Thank you!</P> Mon, 26 Sep 2022 11:25:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-if-funciotn/m-p/2796174#M87867 FILIPKACZMAR 2022-09-26T11:25:24Z