remove rows in a table based on a condition.

[NeilJustice]

I have a table imported into power BI (sample below) i want to be able to filter either the table or when i create a visual that will only show me the row with the highest Transaction Id, in this example it would be the first rows. I do not want to see the other rows as the total invoice amount is the same. In esscence it is the same transaction but has gone through a series of workflows, so i only want to see the one with the higher Transaction Id, all transaction ids are a unique number. The table has thousands of lines with multiple invoice Ids the same or just one line, any ideas how i can resolve this. sorry but it wont let me upload the xls table 

 

Date

Account no

Invoice id

Transaction id

invoice number

department

cost centre no

cost centre description

supplier name

supplier site code

invoice header description

total invoice amount

transaction type

po number

account code description

3/4/2023

5224102064

104998736

10499873641

AB12345

DP1

10254000

WFLC

A Supplier LTD

ABC123

Desc

3,991.37

Non-PO

Other fees

3/4/2023

5224102064

104998736

10499873631

AB12345

DP1

10254000

WFLC

A Supplier LTD

ABC123

Desc

3,991.37

Non-PO

Other fees

3/4/2023

5224100011

104998736

10499873611

AB12345

DP1

10254000

WFLC

A Supplier LTD

ABC123

Another description

3991.37

Non-PO

Pending Allocation

[Dangar332]

Hi, @NeilJustice 

You can try to make new table 

Addcolumn ('yourtable',"hightranid", calculate (maxx ( filter ('yourtable','yourtable'[Invoice id]), 'yourtable'[Transaction id])))

You can make new measure which use instead of transaction Id column 

New measure= 

maxx ( filter ('yourtable','yourtable'[Invoice id]), 'yourtable'[Transaction id])

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.