Conditional Concatenation

[Anonymous]

Hi,

Each account has a unique id and should only contain one member but some have two. I can't change this.

I have used the code below with success.

Holiday Region(s) = CONCATENATEX('Member','Member'[Region],", ")

This produces the desired results in the format "France , Germany" , "Spain , Spain" , "Italy"

In this scenario, where the regions are same "Spain , Spain" . I would like for the concatenation to only display one value "Spain".

Thanks in advance 🙂

[Anonymous · Accepted solution]

See if this is could work:

Measure = 
CONCATENATEX(
    DISTINCT(Concate[Region]),Concate[Region], ",")