cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johanthedataman Frequent Visitor
Frequent Visitor

Top N and Others as part of the Total

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:

 

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

 

Other - Not Working.JPGTopN - Not Working.JPGOther - Working Ok.JPGTopN - Working Ok.JPGVisual.JPG

 

Any help is more than welcome Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Top N and Others as part of the Total

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: Top N and Others as part of the Total

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.