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(
ISFILTERED(TrackingTicket[employee]),
SELECTEDVALUE(TrackingTicket[employee],
CONCATENATEX(VALUES(TrackingTicket[employee]), TrackingTicket[employee], & UNICHAR(10))
), "All Employees"
)

 

 

Thank you

 

Arvin

Need Help
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    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

4 Replies

  • dtartaglia's avatar
    dtartaglia
    Resolver I
    8 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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?

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    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

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    8 years ago

    Hi Anonymous,

     

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

     

    Regards,
    Frank