Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@VladyOselsky , not a straight forward solution as of now
Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
@VladyOselsky , not a straight forward solution as of now
Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |