Showing Text in a Matrix Only for a Certain Rows Only

[Anonymous]

Hi,

I am trying to work out how I can show text values in a matrix but without showing it for the top part of each section (in the row). To show you an example, my source data looks like the following:

Ticket ID	Ticket Category	Ticket Agent
1	After Sales	Bob
2	Pre Sales	Marty
3	After Sales	Sam
4	Unrelated	Billie

I want to set up a matrix where the rows contains Ticket Category, underneath each one would contain the ticket ID associated with the ticket category AND the ticket agent assigned. I only want the ticket agent to appear for the ticket ID row and not for the ticket category row (as multiple people would have been assigned tickets in that area).

 To show you an example, this is what it looks like when I just drag the Ticket Agent field to the Values section.

Ticket Category	Agent
After Sale  - 1 - 3	Bob Bob Sam
Pre Sale  - 2	Marty Marty
Unrelated  - 4	Billie Billie

Ideally what I would like is for the values to dissapear next to ticket category, resulting in a matrix that looks like the below:

Ticket Category	Agent
After Sale  - 1 - 3	Bob Sam
Pre Sale  - 2	Marty
Unrelated  - 4	Billie

Is there anyway to do this with DAX and creating measures? I am bit a stumped with this one, your help is kindly appreciated.

[parry2k]

@Anonymous and here is the output

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Thank you so much this is exactly what I needed. Thanks 🙂

[parry2k · Accepted solution]

@Anonymous use this measure in the values:

Ticket Agent Measure = IF ( ISINSCOPE ( 'Table'[Ticket ID] ), MAX ( 'Table'[Ticket Agent] ) ) 

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡