Concatenatx

[Anonymous]

Hi Guys,

May I ask what is the problem with my dax expression? I want to concatenate "next new line" every after selected values on the parameter.

Here's the expression:

SelectedEmp = IF(
ISFILTERED(TrackingTicket[employee]),
SELECTEDVALUE(TrackingTicket[employee],
CONCATENATEX(VALUES(TrackingTicket[employee]), TrackingTicket[employee], & UNICHAR(10))
), "All Employees"
)

Thank you

Arvin

[v-frfei-msft]

Hi @Anonymous,

Does that make sense? If so , could you please mark this answer as solution?

Regards,
Frank

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Based on my test, we can update your formula like this:

Measure = IF(ISFILTERED(TrackingTicket[employee]),CONCATENATEX(ALLSELECTED(TrackingTicket[employee]),TrackingTicket[employee]& UNICHAR(10)),"All Employee")

Then we can get the result as below.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/qyl8cx34biv9g00/tes.pbix?dl=0

Regards,
Frank

[dtartaglia]

Hi @Anonymous what's the desired output look like in a a visual, table, ect?

[Anonymous]

Hi @dtartaglia thank you for taking time responding on my inquiry. The desired output look like is this:

When nothing is selected on the Parameter/Filter, it will shows on the CARD, "All Employees". 

When one is selected, it will shows, "Employee 1".

When multiple are selected, it will shows,

Employee 1,

Employee 2,

Employee 3

something like this.

Is this possible?