Filter by Top N or ___

[JrBIAnalyst]

I'm pretty sure this isn't (easily) doable but looking for confirmation or ideas.

I'm working on a peer comparison dashboard - published data from other similar entities plus my own company. I'd like to set up a filter on visuals to show my company alongside the top 5 in a given category. In other words, filter by "Top five companies by sum of operating expenses OR CompanyName = MyCompany."

Top N filter? Easy. CompanyName = MyCompany? Easy. Putting them together... not seeing an easy way to do that, so any ideas or pointers (or just confirmation that it isn't possible) are very much appreciated.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file if it suits your requirement.

I hope the below can provide some ideas on how to create a solution for your datamodel.

[JrBIAnalyst]

Thanks! That'll do the trick. 

[AlexisOlson]

I don't think this is possible with just the filter pane options but you can do pretty much any logic with a measure filter. Here's an example from another post:
https://community.fabric.microsoft.com/t5/Desktop/Measure-value-will-filter-measure-in-visual/td-p/2...