Forum Discussion

JK-1's avatar
JK-1
Helper II
1 year ago
Solved

DAX to de-duplicate text string?

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  🙂  thanks in advance   Address Area Distributio...
Show and Tell
suggestions
  • Chanty4u's avatar
    Chanty4u
    1 year ago

    Try this.DeDuplicatedString =

    CALCULATE(

        CONCATENATEX(

            VALUES('Table'[Area]), -- <-- this removes duplicates

            'Table'[Area],

            "; ",

            'Table'[Area]

        ),

        ALLEXCEPT('Table', 'Table'[Addr

    ess])

    )

techies's avatar
techies
Super User
1 year ago

Hi JK-1 please try this calculated column

 

DeDuplicatedAreas =
VAR CurrentAddress = AddressAreas[Address]
VAR DistinctAreas =
    CALCULATETABLE(
        VALUES(AddressAreas[Area]),
        FILTER(
            ALL(AddressAreas),
            AddressAreas[Address] = CurrentAddress
        )
    )
RETURN
    CONCATENATEX(
        DistinctAreas,
        AddressAreas[Area],
        "; ",
        AddressAreas[Area], ASC
    )