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],"; ")