topic Re: DAX to de-duplicate text string? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760376#M182286 <P>I do not get the question</P> Fri, 11 Jul 2025 18:44:55 GMT FBergamaschi 2025-07-11T18:44:55Z DAX to de-duplicate text string? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760373#M182285 <P>Would it be possible to get DAX de-duplicating a text string? In the example below - or any suggestions on alternate ways, but still using DAX&nbsp; <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp; thanks in advance</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Address</TD><TD>Area</TD><TD>Distribution</TD><TD>string = CONCATENATEX(FILTER(('Table'),'Table'[Address]=EARLIER('Table'[Address])),'Table'[Area],"; ")</TD><TD>would then like it de-duplicated -- but wondered if DAX could facilitate?</TD></TR><TR><TD>George Street</TD><TD>1st Floor</TD><TD>Zone 3</TD><TD>1st Floor; 1st Floor; 2nd Floor</TD><TD>1st Floor; 2nd Floor</TD></TR><TR><TD>George Street</TD><TD>2nd Floor</TD><TD>Zone 1</TD><TD>1st Floor; 1st Floor; 2nd Floor</TD><TD>1st Floor; 2nd Floor</TD></TR><TR><TD>George Street</TD><TD>1st Floor</TD><TD>Zone 5</TD><TD>1st Floor; 1st Floor; 2nd Floor</TD><TD>1st Floor; 2nd Floor</TD></TR><TR><TD>Lime Walk</TD><TD>Basement</TD><TD>Zone 7</TD><TD>Basement; Basement</TD><TD>Basement</TD></TR><TR><TD>Lime Walk</TD><TD>Basement</TD><TD>Zone 4</TD><TD>Basement; Basement</TD><TD>Basement</TD></TR><TR><TD>Hope Avenue</TD><TD>Basement</TD><TD>Zone 2</TD><TD>1st Floor; 1st Floor; Basement</TD><TD>Basement; 1st Floor</TD></TR><TR><TD>Hope Avenue</TD><TD>1st Floor</TD><TD>Zone 8</TD><TD>1st Floor; 1st Floor; Basement</TD><TD>Basement; 1st Floor</TD></TR><TR><TD>Hope Avenue</TD><TD>1st Floor</TD><TD>Zone 5</TD><TD>1st Floor; 1st Floor; Basement</TD><TD>Basement; 1st Floor</TD></TR><TR><TD>Market Square</TD><TD>2nd Floor</TD><TD>Zone 6</TD><TD>2nd Floor</TD><TD>2nd Floor</TD></TR></TBODY></TABLE> Fri, 11 Jul 2025 18:42:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760373#M182285 JK-1 2025-07-11T18:42:04Z Re: DAX to de-duplicate text string? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760376#M182286 <P>I do not get the question</P> Fri, 11 Jul 2025 18:44:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760376#M182286 FBergamaschi 2025-07-11T18:44:55Z Re: DAX to de-duplicate text string? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760390#M182287 <P>Try this.DeDuplicatedString =</P><P>CALCULATE(</P><P>&nbsp; &nbsp; CONCATENATEX(</P><P>&nbsp; &nbsp; &nbsp; &nbsp; VALUES('Table'[Area]), -- &lt;-- this removes duplicates</P><P>&nbsp; &nbsp; &nbsp; &nbsp; 'Table'[Area],</P><P>&nbsp; &nbsp; &nbsp; &nbsp; "; ",</P><P>&nbsp; &nbsp; &nbsp; &nbsp; 'Table'[Area]</P><P>&nbsp; &nbsp; ),</P><P>&nbsp; &nbsp; ALLEXCEPT('Table', 'Table'[Addr</P><P>ess])</P><P>)</P> Fri, 11 Jul 2025 19:15:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760390#M182287 Chanty4u 2025-07-11T19:15:42Z Re: DAX to de-duplicate text string? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760449#M182291 <P>Chanty4u is right. You can also only use</P><DIV><DIV><SPAN>String =</SPAN></DIV><P>CONCATENATEX(</P><P>VALUES('Table'[Area]), -- &lt;-- this removes duplicates</P><P>'Table'[Area],</P><P>"; ",</P><P>'Table'[Area]</P><BR /><DIV><SPAN>If u only us the adres</SPAN></DIV></DIV> Fri, 11 Jul 2025 21:16:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760449#M182291 JJ_3 2025-07-11T21:16:03Z Re: DAX to de-duplicate text string? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760617#M182297 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="927611" data-lia-user-login="JK-1" class="lia-mention lia-mention-user">JK-1</a>&nbsp;please try this calculated column</P><P>&nbsp;</P><DIV><DIV><SPAN>DeDuplicatedAreas =</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>CurrentAddress</SPAN><SPAN> = </SPAN><SPAN>AddressAreas</SPAN><SPAN>[Address]</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>DistinctAreas</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATETABLE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>AddressAreas</SPAN><SPAN>[Area]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>AddressAreas</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>AddressAreas</SPAN><SPAN>[Address]</SPAN><SPAN> = </SPAN><SPAN>CurrentAddress</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CONCATENATEX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DistinctAreas</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>AddressAreas</SPAN><SPAN>[Area]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"; "</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>AddressAreas</SPAN><SPAN>[Area]</SPAN><SPAN>, </SPAN><SPAN>ASC</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Sat, 12 Jul 2025 07:07:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-de-duplicate-text-string/m-p/4760617#M182297 techies 2025-07-12T07:07:46Z