Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Concatenatx

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(...
  • v-frfei-msft's avatar
    8 years ago

    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