Forum Discussion

pdbenbow's avatar
pdbenbow
Icon for Resolver II rankResolver II
7 years ago
Solved

Concatenating data within RELATEDTABLE output

My report has a list of email addresses, and the request from the users is to have a "mailto" hyperlink they can click to send an email to all addresses.  The list needs to be dynamic based on slicer...
  • pdbenbow's avatar
    pdbenbow
    7 years ago

    I was able to get what I needed by converting the calculated column into a measure.

     

    DAX:

    Email All = "mailto: " & CONCATENATEX(VALUES(ENVH[Email]),ENVH[Email],"; ")
crjackson's avatar
crjackson
Icon for Helper I rankHelper I
3 years ago

can you make an actual button with this measure? i got it to work but it will only work in a table. I set the button to weburl and add the measure but nothing happens.

pdbenbow's avatar
pdbenbow
Icon for Resolver II rankResolver II
3 years ago

We got it to work with a button. Not sure if this applies to your situation, but "mailto" has a limit of 2,000 characters. We found the button would not function if the concatenated list was over 2,000 characters long. We used slicers so our users could break the list down into smaller, more manageable groups. This allows them to get the "mailto" under 2,000 characters, which allows the button to function.

  • crjackson's avatar
    crjackson
    Icon for Helper I rankHelper I
    3 years ago

    Hmmm. I have a slicer and it still doesn't work for me even with just two email addresses