exclude duplicate displayed in matrix table

[summer18]

Hi, 

When I created a matrix table in my dashboard, I want to exclude specific rows where there are duplicate invoice line number and null PO Number. In the column "exclude", it displays the tag which I want to be excluded from my matrix table.

I tried to create the "exclude" column tag in PowerBI but could not make it work properly if the columns are displayed in matrix table.

I'm not sure if this will help: In the matrix table, it's showing duplicate but in the backend there are more than 2 count.

[amitchandak]

@summer18 , Looking at sample data you can take PO Number as value in Matrix as Min or Max. Or in the table as Min/max or first/last in table

or use formula for PO firstnonblank(Table[Po],blank())