TopN & Others with multiple drill down

[superBro22]

I have the following table:

And the folowing matrix visual and slicer:

Now , I need to add Vendor column to my matrix visual  as drill down but keeping my TopN order. This is the result I get and it is not correct because I am filtering top 3: 

I'd like a way to show only the Top N values and subvalues. For example: Show Top 1:

But I can not find a way to do so. 

Find attached the Pbix.  

https://wetransfer.com/downloads/809d92c163452268d1f263adc804217120221013095358/ea2343a66070f801b194... 

Can someone help me please?

[v-binbinyu-msft]

Hi @superBro22 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[superBro22]

Hi @v-binbinyu-msft ,

This is the Pbix link: https://wetransfer.com/downloads/809d92c163452268d1f263adc804217120221013095358/ea2343a66070f801b194...

I have the following table:

And the folowing matrix visual and slicer:

Now , I need to add Vendor column to my matrix visual  as drill down but keeping my TopN order. This is the result I get and it is not correct because I am filtering top 3: 

I'd like a way to show only the Top N values and subvalues. For example: Show Top 1:

But I can not find a way to do so

Thanks!!