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.
