Forum Discussion
Advocate IDynamic Top N and Others
The key to it woyld be to use a calculated table with an extra member for Others. I recently wrote a similar blog
http://sqljason.com/2017/03/dynamic-grouping-in-power-bi-using-dax.html
In this case, the measure in my blog will have to be replaced by the TopN part. Let me know if you have difficulties applying this and if yes, I can explain in more detail (especially if you can give sample data and show the results also, so that I can put it together in apower bi file)
Advocate II have a problem with implementing a donut showing top N and Others groups for a measure. My underlying dimension data is of below type:
| Product | Group |
| 1 | A |
| 2 | A |
| 3 | A |
| 4 | B |
| 5 | B |
| 6 | B |
| 7 | C |
| 8 | C |
| 9 | C |
| 10 | C |
It has a measure connected on Product column. I need to get the top N [Group] as shown below where the blue segment is "Others" group.
The problem is with naming the "Others" as when I am doing it in another calculated column, it is static and doesn't work well when any filters are applied on the report. Is there any way to make it responsive to filters, so that respective Top N [Group] are shown for different selection ?