How to list values of a column based on another column in power bi measure/dax

Question

I have two columns in a table

Ticket   ContactPerson
A         John
B         Unassigned
C         Harry
D         Unassigned
E         Unassigned

how can I get only tickets which has ContactPerson as "Unassigned" ?? Output should be tickets - B,D,E only and should not include the ContactPerson column which has values "Unassigned" as this is irrelevant for me. I can write Unassigned in Header itself no need to add extra column

I want to see this column in my visual

Tickets
B
D
E

And not this

Contact Person Tickets
Unassigned     B
Unassigned     D
Unassigned     E

Answer 1

To show just those rows that have an "Unassigned" attribute value, you should be able to just filter the visual in Power BI.

For example the left hand table has all values, the right hand table is filtered to just "Unassigned", but only showing those tickets relating to unassigned