Forum Discussion
hide collapsed row value for Matrix Visualization
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.
If(
Isinscope( table[JobNum]),
Selectedvalue( table[jobDesc])
)
2 Replies
If(
Isinscope( table[JobNum]),
Selectedvalue( table[jobDesc])
)