Creating a DAX measure to concatenate two or more course titles.

[justlearning50]

Hello,

I have a situation where I've created a very simple bar chart to display the number of courses run on a given day. So Y axis is simply 'Count of Table{course title]' and the x axis is the date. 

I want to add a tooltip for the course name. Where there is only one course, no problem, but two or more - it only displays the first/last course name. I want to create a measure that concatenates all the course names, so when I hover over a bar on my barchart, it will display all the course names. 

This is my current measure

All_Titles =

    CONCATENATEX

    (

        'TableName',

       SELECTEDVALUE

    (

        'TableName[Title]

    ),

";")

This returns the coursename for a single item or a ';' for more than one

If I use CONCATENATE it will return the coursename; for a single item or again ';' for more than one. 

I have thought about creating a variable and iterating through all the coursenames for a given date and appending the name to the variable, but not sure how to do this without a FOREACH function, and I don't believe this exists in DAX.

To try it, I created this measure:

All_Titles =

var _coursenamestring = SELECTEDVALUE('TableName'[Title])

RETURN

    CALCULATE

    (

        CONCATENATEX

        (

            'TableName',

            _coursenamestring &  ";"    

        )

    )

 No difference in result, but I didn't really expect it to. 

Can anyone help here, please? I think this should be pretty easy, but I cannot think how to do it.

Thanks alot for your help.

[lbendlin · Accepted solution]

CONCATENATEX(Table,[Column],";")

[justlearning50]

Thank you. I actually though I had tried this before the version I added above. But it works now anyway. Tks again.

[johnt75]

You don't need SELECTEDVALUE, that works on the filter context but inside an iterator you have a row context. Try

All_Titles =
CONCATENATEX ( VALUES ( 'TableName'[Title] ), 'TableName'[Title], ";" )

[justlearning50]

@johnt75 Thanks for replying. This didn't allow me to add the second column, unfortunately.