Forum Discussion
Dynamic 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)
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)
SqlJason how would you be able to keep the others at the botom of the table?
Eg.,
| Name | Value |
| Name 1 | 100 |
| Name 2 | 90 |
| Name 3 | 40 |
| Other | 80 |
In this case one would need an assistance column for the shorting part. An idea could be to have a calculated index column based on the Value. However, how to do it since Value is not have a calculate dcolumn but a measure?