Custom Row of Excluded Data in Table or Matrix

[VladyOselsky]

Hello, I'm not sure if what I'm trying to achieve should be easy or not. Concept is straight forward. I created a slicer that lets user select top N customers. However now they want to see extra row in Table that shows all excluded customers as sum of data.

My table is straight forward with 1 line per customer with whole buch of calculations that I did in SQL before bringing that data into Power BI.

Example in the screetshot is taking base table A and making it look like Table B by suming TotalSales for Customer E and F because they got excluded by Filter.

 

[amitchandak · Accepted solution]

@VladyOselsky , not a straight forward solution as of now

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE