https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/contain/m-p/814251#M5344 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="157191" data-lia-user-login="honeye_alem" class="lia-mention lia-mention-user">honeye_alem</a>&nbsp;,</P><P>Try using a var above your CALCULATE()&nbsp;</P><P>var Test = If CONTAINS(table,[colname],"Donate"), TRUE())<BR />Let me know if you have any questions.<BR /><BR />If this solves your issues, please mark it as the <STRONG>solution, </STRONG>so that others can find it easily. <STRONG>Kudos </STRONG>are nice too.<BR />Nathaniel</P> Thu, 10 Oct 2019 03:45:56 GMT Nathaniel_C 2019-10-10T03:45:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/contain/m-p/814183#M5342 <P>hello fiends. I need to have contain in my calculate function but i don't know how can I us it . condition is : one column contain "Donate"</P> Thu, 10 Oct 2019 02:25:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/contain/m-p/814183#M5342 honeye_alem 2019-10-10T02:25:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/contain/m-p/814251#M5344 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="157191" data-lia-user-login="honeye_alem" class="lia-mention lia-mention-user">honeye_alem</a>&nbsp;,</P><P>Try using a var above your CALCULATE()&nbsp;</P><P>var Test = If CONTAINS(table,[colname],"Donate"), TRUE())<BR />Let me know if you have any questions.<BR /><BR />If this solves your issues, please mark it as the <STRONG>solution, </STRONG>so that others can find it easily. <STRONG>Kudos </STRONG>are nice too.<BR />Nathaniel</P> Thu, 10 Oct 2019 03:45:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/contain/m-p/814251#M5344 Nathaniel_C 2019-10-10T03:45:56Z