hide collapsed row value for Matrix Visualization

[Corey_M]

Sample Dataset:

JobNum	JobDesc	Assigned_to
1	Job A	Adam
2	Job B	Bob
3	Job C	Charlie
4	Job D	Charlie
5	Job E	Eve
6	Job F	Adam

Goal:

when Matrix is collapsed there is no value shown for job description. (the blank values shown in M_description but for every row)

Attempt so far:

Using a measure to return blank if there is more than 1 associated value as there would be in totals, but this fails when there is only one job associated with a person.

M_Description = IF(HASONEVALUE('Table'[JobDesc]),MAX('Table'[JobDesc]),BLANK())

I feel like there is probably a setting in the visual but I have yet to find it.

[Deku · Accepted solution]

If(

Isinscope( table[JobNum]),

Selectedvalue( table[jobDesc])

)

[Corey_M]

I will caveat that this solution doesn't appear to work if I only use these measures as the values (the entire matrix returns emtpy) but that is not an issue in my use case

and then it works fine when I add just a regular column.