Forum Discussion
pdbenbow
Resolver II
Resolver IIConcatenating 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...
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],"; ")
pdbenbowResolver II
Resolver III 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],"; ")
Well, my formula was A MEASURE. When I create a calculated column I state this fact explicitly.
Slicers NEVER affect calculated columns the way you thought. They can only filter the columns for certain values that have been precalculated in there, nothing else.
Best
Darek