Encapsulating/Grouping based on TopN

[ronald_balza]

Hi PowerBi Friends,

I have a sample data and wanted to group/encapsulate it based on the TopN given. In addition, I am getting a null value here showing which I think is not good idea to be included as well. Do I need to have a custom table and have a relationship into it? Attached is the sample pbix file which you can play around. Thanks for the help!

Dropbox - File Deleted

End result will be like this. Thanks alot!

[EnterpriseDNA]

Hi @ronald_balza , we noticed you posted a modified version of the same questions as this original post:

Grouping based on Topn - Not adding together

Hi PowerBi Friends, I have a table and grouped it based on TopN. However, the same entity (company name) is splitting into other TopN where it shouldn’t be. e.g Company XYZ was on Top10 and also showing in the Top50 as well. It should be summed together and only be placed on 1 particular TopN. How can I do this? Attached is my measure. Total Invoice By Rank Group = CALCULATE( [Total Invoice], FILTER( FactFinalisedInvoicesDetailed, COUNTROWS( FILTER…

We are marking this thread as “Solved” since your original query was solved by @Harsh on the other thread. If you have further inquiry for another topic, kindly create a new thread.