topic Re: DAX to count based wild card search in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-count-based-wild-card-search/m-p/1641837#M33354 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="243948" data-lia-user-login="Seer_Bug" class="lia-mention lia-mention-user">Seer_Bug</a>&nbsp;,</P> <P><img /></P> <P><img /></P> <P>&nbsp;</P> <LI-CODE lang="markup">COUNT CONTAINSSTRING = CALCULATE ( COUNT ( 'Table'[Frontline Failuers] ), FILTER ( ALL ( 'Table'[Frontline Failuers] ), CONTAINSSTRING ( 'Table'[Frontline Failuers], SELECTEDVALUE ( 'Search'[Frontline Failures] ) ) ) )</LI-CODE> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 03 Feb 2021 15:45:08 GMT Payeras_BI 2021-02-03T15:45:08Z DAX to count based wild card search https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-count-based-wild-card-search/m-p/1641799#M33352 <P>Hi All,&nbsp;</P><P>Data looks like this :</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Audit ID</TD><TD>Emp Name</TD><TD>Frontline Failuers</TD></TR><TR><TD>1</TD><TD>ABC</TD><TD>Credit not offered</TD></TR><TR><TD>2</TD><TD>DEF</TD><TD>Did not approach their Manager;System Probing;Reconfirming</TD></TR><TR><TD>3</TD><TD>EFR</TD><TD>No Failure</TD></TR><TR><TD>4</TD><TD>TGR</TD><TD>Lack of Authorisation</TD></TR><TR><TD>5</TD><TD>RUJ</TD><TD>Objection handling;System Probing</TD></TR><TR><TD>6</TD><TD>IKU</TD><TD>Did not approach their Manager</TD></TR><TR><TD>7</TD><TD>OLJ</TD><TD>System Probing</TD></TR><TR><TD>8</TD><TD>OLI</TD><TD>Credit not offered;Objection handling</TD></TR><TR><TD>9</TD><TD>TGR</TD><TD>Lack of Authorisation</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>looking for a result like this using DAX :</P><TABLE><TBODY><TR><TD><STRONG>Frontline Failures</STRONG></TD><TD><STRONG>Count</STRONG></TD></TR><TR><TD>Credit not offered</TD><TD>2</TD></TR><TR><TD>Did not approach their Manager</TD><TD>2</TD></TR><TR><TD>No Failure</TD><TD>1</TD></TR><TR><TD>Lack of Authorisation</TD><TD>2</TD></TR><TR><TD>Objection handling</TD><TD>2</TD></TR><TR><TD>Did not approach their Manager</TD><TD>2</TD></TR><TR><TD>System Probing</TD><TD>3</TD></TR></TBODY></TABLE><P>Thanks</P> Wed, 03 Feb 2021 12:20:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-count-based-wild-card-search/m-p/1641799#M33352 Seer_Bug 2021-02-03T12:20:53Z Re: DAX to count based wild card search https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-count-based-wild-card-search/m-p/1641837#M33354 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="243948" data-lia-user-login="Seer_Bug" class="lia-mention lia-mention-user">Seer_Bug</a>&nbsp;,</P> <P><img /></P> <P><img /></P> <P>&nbsp;</P> <LI-CODE lang="markup">COUNT CONTAINSSTRING = CALCULATE ( COUNT ( 'Table'[Frontline Failuers] ), FILTER ( ALL ( 'Table'[Frontline Failuers] ), CONTAINSSTRING ( 'Table'[Frontline Failuers], SELECTEDVALUE ( 'Search'[Frontline Failures] ) ) ) )</LI-CODE> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 03 Feb 2021 15:45:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-count-based-wild-card-search/m-p/1641837#M33354 Payeras_BI 2021-02-03T15:45:08Z