Forum Discussion

Spotto's avatar
Spotto
Helper IV
4 years ago
Solved

How to ignore CONCATENATEX duplicates

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
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Spotto
      Helper IV
      4 years ago

      it worked, thank you very much🙂