How to ignore CONCATENATEX duplicates

[Spotto]

hello everyone, I need some help, I'm making a measurement in a direct query table using CONCATENATEX.
The measure I put it to not bring the blank fields but the problem is that when I put the result it brings me a duplicate, I don't know how to fix the measure to disregard the duplicates.

Nr Salesforce Reverso =

var nrsalesrev =

CONCATENATEX(

FILTER('gdp tb_Pagamento_Contrato','gdp tb_Pagamento_Contrato'[SalesForce_Reverso]<> BLANK()),

'gdp tb_Pagamento_Contrato'[SalesForce_Reverso],

", "

)

return nrsalesrev

tks for help

[Anonymous · Accepted solution]

Hi @Spotto ,

You can update the formula of measure [Nr Salesforce Reverso] as below to get it:

Nr Salesforce Reverso =

VAR nrsalesrev =

CONCATENATEX (

FILTER (

VALUES ( 'gdp tb_Pagamento_Contrato'[SalesForce_Reverso] ),

'gdp tb_Pagamento_Contrato'[SalesForce_Reverso] <> BLANK ()

),

'gdp tb_Pagamento_Contrato'[SalesForce_Reverso],

", "

)

RETURN

nrsalesrev

Best Regards

[Spotto]

it worked, thank you very much🙂