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],"; ")
Anonymous's avatar
Anonymous
Not applicable
7 years ago
[Email All] =
var __concatenatedEmails =
	CONCATENATEX(
		DISTINCT( ENVH[Email] ),
		ENVH[Email],
		"; "
	)
var __mailtoString =
	"mailto:" & __concatenatedEmails
return
	__mailtoString
pdbenbow's avatar
pdbenbow
Icon for Resolver II rankResolver II
7 years ago

Nope, doesn't work. That gives me the exact same result as my original formula:

Original formula:

Email All = "mailto:" & CONCATENATEX( ENVH, ENVH[Email], "; ")

 

Here is the output when not sliced:

Here is the output when sliced:

 

The slicer is having no effect. When I toggle that slicer, there should only be three email addresses listed.