https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2925210#M96070 <P>Hello team, I want to calculate</P><P>&nbsp;</P><UL><LI><SPAN><SPAN> </SPAN></SPAN><img /><P> </P></LI></UL><P>&nbsp;the length of the product description of only those products whose product color is NA.</P><P>Using ONLY string functions.</P><P>Thanks in advance.&nbsp;</P> Wed, 23 Nov 2022 18:37:08 GMT aditi11 2022-11-23T18:37:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2925210#M96070 <P>Hello team, I want to calculate</P><P>&nbsp;</P><UL><LI><SPAN><SPAN> </SPAN></SPAN><img /><P> </P></LI></UL><P>&nbsp;the length of the product description of only those products whose product color is NA.</P><P>Using ONLY string functions.</P><P>Thanks in advance.&nbsp;</P> Wed, 23 Nov 2022 18:37:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2925210#M96070 aditi11 2022-11-23T18:37:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2925788#M96102 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="455316" data-lia-user-login="aditi11" class="lia-mention lia-mention-user">aditi11</a>&nbsp;</P> <P>&nbsp;</P> <P>Sample data:</P> <P><img /></P> <LI-CODE lang="markup">Measure = CALCULATE ( COUNT ( 'Table'[Product] ), FILTER ( ALL ( 'Table' ), [ProductColor] = "NA" ) ) </LI-CODE> <P><img /></P> <P>Is this the result you expect?</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Community Support Team _Charlotte</P> <P>If this post<SPAN>&nbsp;</SPAN><STRONG>helps</STRONG>, then please consider<SPAN>&nbsp;</SPAN><STRONG><EM>Accept it as the solution</EM></STRONG><SPAN>&nbsp;</SPAN>to help the other members find it more quickly.</P> Thu, 24 Nov 2022 02:49:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/2925788#M96102 v-zhangti 2022-11-24T02:49:00Z