CONCATENATEX DISTINCT OR VALUES

[L_B]

hi all,

Verantw. Ceelbaas = CONCATENATEX(

FILTER(

ALL(Dim_Dokplan_Ceel),

Dim_Dokplan_Ceel[index date shift scheepsnaam] = Fact_Dokplan_AET[index date shift scheepsnaam]),

Dim_Dokplan_Ceel[Verantw. Ceelb], ",")

I've just writtten above formula (for to have a new column) to retrieve some names of different persons but sometimes the same name disappears twice.

How can I eliminate these duplicates values? 

I've already read to use DISTINCT or VALUES but it does not work. 

I've tried the following formulas:

Verantw. Ceelbaas = CONCATENATEX(DISTINCT(

FILTER(

ALL(Dim_Dokplan_Ceel),

Dim_Dokplan_Ceel[index date shift scheepsnaam] = Fact_Dokplan_AET[index date shift scheepsnaam])),

Dim_Dokplan_Ceel[Verantw. Ceelb], ",")

 'measure' = CONCATEX ( VALUES (Fact_Table [Verantw. Ceelbaas]), Fact_Table [Verantw. Ceelbaas]))

thanks for your advice

[v-lionel-msft]

Hi @L_B ,

Please show me your sample data, I can't reproduce your data model.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft]

Hi @L_B ,

Please show me your sample data, I can't reproduce your data model.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[L_B · Accepted solution]

@v-lionel-msft ,

thanks for your reply! However, my data is GDPR-sensitive so it is impossible to share this.

grtz! 

[L_B]

CONCATEX ==> this was ofc a typo... 🙂