Issue with Matrix displaying first/last item in the value field when matrix is collapsed.

[justlearning50]

Hello,

I've created a matrix. In the rows I have a course name and skill code - expand the course name to see the skills. In the values I want the skill name. However with all rows collapsed, the default value is either the first or last skill name .

I would like to make that either nothing, or a message "Expand to see skills". 

I feel I should be able to use an IF statement

IF(

ISINSCOPE(Course name), "Expand to see Skills", Column[SkillName]

)

but I cannot add in a column into the IF statement. 

Is there any way to get round this. I feel there should be. 

I could concatenate the code and name and that would work, but it doesn't look great. 

Thanks alot for any help.

[SamWiseOwl · Accepted solution]

Hi @justlearning50 
What you need is to specific one value for the column:
SelectedValue(table[Column])

Should do the trick 🙂

In my example when I expand the Towns I want to see the CentreNames:

Column Measure =

If(ISINSCOPE(Centre[CentreName])

, SELECTEDVALUE(Centre[CentreName]), "Click for more info")

I think showing nothing would look neater.
So use "" and maybe change the column header:

[justlearning50]

Thank you very much. That is great to know.