Forum Discussion

summer18's avatar
summer18
Helper III
5 years ago

exclude duplicate displayed in matrix table

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.

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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())