topic remove rows in a table based on a condition. in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/remove-rows-in-a-table-based-on-a-condition/m-p/3465696#M132251 <P>&nbsp;</P><P>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&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P> </P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>Account no</TD><TD>Invoice id</TD><TD>Transaction id</TD><TD>invoice number</TD><TD>department</TD><TD>cost centre no</TD><TD>cost centre description</TD><TD>supplier name</TD><TD>supplier site code</TD><TD>invoice header description</TD><TD>total invoice amount</TD><TD>transaction type</TD><TD>po number</TD><TD>account code description</TD></TR><TR><TD>3/4/2023</TD><TD>5224102064</TD><TD>104998736</TD><TD>10499873641</TD><TD>AB12345</TD><TD>DP1</TD><TD>10254000</TD><TD>WFLC</TD><TD>A Supplier LTD</TD><TD>ABC123</TD><TD>Desc</TD><TD>3,991.37</TD><TD>Non-PO</TD><TD>&nbsp;</TD><TD>Other fees</TD></TR><TR><TD><P>3/4/2023</P></TD><TD>5224102064</TD><TD>104998736</TD><TD>10499873631</TD><TD>AB12345</TD><TD>DP1</TD><TD>10254000</TD><TD>WFLC</TD><TD>A Supplier LTD</TD><TD>ABC123</TD><TD>Desc</TD><TD>3,991.37</TD><TD>Non-PO</TD><TD>&nbsp;</TD><TD><P>Other fees</P></TD></TR><TR><TD><P>3/4/2023</P></TD><TD>5224100011</TD><TD>104998736</TD><TD>10499873611</TD><TD>AB12345</TD><TD>DP1</TD><TD>10254000</TD><TD>WFLC</TD><TD>A Supplier LTD</TD><TD>ABC123</TD><TD>Another description</TD><TD>3991.37</TD><TD>Non-PO</TD><TD>&nbsp;</TD><TD><P>Pending Allocation</P></TD></TR></TBODY></TABLE> Sun, 08 Oct 2023 15:16:43 GMT NeilJustice 2023-10-08T15:16:43Z remove rows in a table based on a condition. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/remove-rows-in-a-table-based-on-a-condition/m-p/3465696#M132251 <P>&nbsp;</P><P>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&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P> </P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>Account no</TD><TD>Invoice id</TD><TD>Transaction id</TD><TD>invoice number</TD><TD>department</TD><TD>cost centre no</TD><TD>cost centre description</TD><TD>supplier name</TD><TD>supplier site code</TD><TD>invoice header description</TD><TD>total invoice amount</TD><TD>transaction type</TD><TD>po number</TD><TD>account code description</TD></TR><TR><TD>3/4/2023</TD><TD>5224102064</TD><TD>104998736</TD><TD>10499873641</TD><TD>AB12345</TD><TD>DP1</TD><TD>10254000</TD><TD>WFLC</TD><TD>A Supplier LTD</TD><TD>ABC123</TD><TD>Desc</TD><TD>3,991.37</TD><TD>Non-PO</TD><TD>&nbsp;</TD><TD>Other fees</TD></TR><TR><TD><P>3/4/2023</P></TD><TD>5224102064</TD><TD>104998736</TD><TD>10499873631</TD><TD>AB12345</TD><TD>DP1</TD><TD>10254000</TD><TD>WFLC</TD><TD>A Supplier LTD</TD><TD>ABC123</TD><TD>Desc</TD><TD>3,991.37</TD><TD>Non-PO</TD><TD>&nbsp;</TD><TD><P>Other fees</P></TD></TR><TR><TD><P>3/4/2023</P></TD><TD>5224100011</TD><TD>104998736</TD><TD>10499873611</TD><TD>AB12345</TD><TD>DP1</TD><TD>10254000</TD><TD>WFLC</TD><TD>A Supplier LTD</TD><TD>ABC123</TD><TD>Another description</TD><TD>3991.37</TD><TD>Non-PO</TD><TD>&nbsp;</TD><TD><P>Pending Allocation</P></TD></TR></TBODY></TABLE> Sun, 08 Oct 2023 15:16:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/remove-rows-in-a-table-based-on-a-condition/m-p/3465696#M132251 NeilJustice 2023-10-08T15:16:43Z Re: remove rows in a table based on a condition. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/remove-rows-in-a-table-based-on-a-condition/m-p/3465772#M132252 <P>Hi, <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="610831" data-lia-user-login="NeilJustice" class="lia-mention lia-mention-user">NeilJustice</a>&nbsp;</P><P>You can try to make new table&nbsp;</P><P>Addcolumn ('yourtable',"hightranid", calculate (maxx ( filter ('yourtable','yourtable'[Invoice id]), 'yourtable'[Transaction id])))</P><P>&nbsp;</P><P>You can make new measure which use instead of transaction Id column&nbsp;</P><P>&nbsp;</P><P>New measure=&nbsp;</P><P>maxx ( filter ('yourtable','yourtable'[Invoice id]), 'yourtable'[Transaction id])</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><STRONG>If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.</STRONG></P><P>&nbsp;</P><P>&nbsp;</P> Sun, 08 Oct 2023 18:41:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/remove-rows-in-a-table-based-on-a-condition/m-p/3465772#M132252 Dangar332 2023-10-08T18:41:43Z