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],"; ")
pdbenbow's avatar
pdbenbow
Icon for Resolver II rankResolver II
7 years ago

The data model is a single table with no relationships. That's why I don't think RELATEDTABLE is what I should be using. There must be another way to concatenate the values after they've been sliced.

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.