Matrix Visual

[radhikalakshmi]

Hello Team,

I tried grouping the JIRA user stories and their child sub-tasks into a matrix visual. In drilled up mode, while I try to add a column to display Team, Assignee name, it is showing a first value while i prefer it is displayed blank. In the drill down mode the data is appearing correctly. 

Drilled up view:

Drilled down view:

Also note that the columns are calculated columns in calculated tables. Can someone help me with a workaround for this? 

Thanks!

Regards,

Radhika

[Anonymous · Accepted solution]

Hi  @radhikalakshmi ,

I have built a data sample based on your screenshot.

Please try to use ISINSCOPE() to identify the Sub-Total field in Matrix visual:

Measure = IF(ISINSCOPE('Table'[Sub-task]),MAX('Table'[Value]),BLANK())

Take a look at the differences:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.