Top N and Others as part of the Total

[johanthedataman]

Hi there,

I'd like to achieve the following:

I want to achieve the following: https://www.oraylis.de/blog/show-top-n-and-rest-in-power-bi#comment-1108, but I can not simulate it. I'm still getting 'others' as the total of the total instead of the total of the rest. I'like to add the following screenshots:

• The correct 100% working DAX code according to the article https://www.oraylis.de/blog/show-top-n-and-rest-in-power-bi#comment-1108
• My Dax-code which is not working 100%
• The current visualization which is not what I want since he shows me 'other' as the total of the total instead of the total of the rest.

Please check the differences between 100% working and not 100% working dax-code, I don't see them ;(

Any help is more than welcome 🙂

[v-yulgu-msft · Accepted solution]

Hi @johanthedataman,

Would you please share the .pbix file for check? Not need to post all detailed data, just share some dummy data that can reproduce the same scenario.

Regards,

Yuliana Gu