TOP N with one permanent Filtered Value

[MrNoob]

I am very new to Power Bi, and I feel this is possible, HOWEVER, I am having some difficulty displaying the data the way I want it.  

So I am working with Multinational data, and want to display my companies data for a given country no matter what.  However as the user slices through the data, the top 5 other companies will change, however always displaying my companies data.

I had tried creating a measure Filtering down my data and performing the calculations and then made one for all others, However, I cannot have both selected in PowerBi, and add the other companies to the Legend

[parry2k]

I guess you are trying to achieve that TOP N shouldn't change even if you use the slicer? Is it correct understanding?

[MrNoob]

I want the Top N to change however, i want to always include a specific company,  

As the top N for each country will change, we want to compare how well our company is doing compared to the Top N companies 

On one line chart

[parry2k]

So let's say if you have top 10 countries by revenue, which value you want to compare against from those top 10 with your company. Sample data and expected output will be helfpul to provide the solution.

[MrNoob]

The expected outcome would be the top 10 companies by Revenue, but also display the 11th company which would always be displayed.  


It is possible to filter by top 10 and exclude a company using the filters built in.  

Working on a sample set

[MrNoob]

https://1drv.ms/x/s!Aga7ypCzQZ2yjhM2bJAdNCsTfZhN

The link should go to a sample set of data that has been scrubbed 

[parry2k · Accepted solution]

I believe the pbix in attach link will get you started, I hope I understood your requirments correctly and solution in PBIX will resolve your issue.

https://drive.google.com/file/d/1O5Z4lJuoUtQ9-GkR7D3zlzLtLoii6Dg7/view?usp=sharing