Aggregate rows in a table

Wael03 — Wed, 19 Apr 2023 07:39:57 GMT

Hello,

I have a dataset displaying the name of a company, his total amount of transactions, and the total count of transaction as you can see here :

In total I have more than a hundred rows, what I would like to do is to display the first 20 rows in the table and aggregate all the other rows as "others" by summing the tran amount and sum tran amount.

Do you know how I could do that ?

Thank you in advance !

Re: Aggregate rows in a table

Anonymous — Thu, 04 May 2023 09:32:02 GMT

Hi Wael03 ，

You may try to add a top n filter in Power BI.

Please kindly refer to

Add a top or bottom n records filter in Microsoft Power BI | TechRepublic

If you also want the bottom row to display the other, you need to create a separate table with the sorted numbers and "other", and then display the results with a SWITCH function to match them.

Best Regards,

Stephen Tao

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

topic Re: Aggregate rows in a table in DAX Commands and Tips

Aggregate rows in a table

Re: Aggregate rows in a table