Different filter on same table depending on external selection

Hi neko_mai 

You can add a table "Little Group Cities" which contains all cities that have asked to have all products shown for them. Just like below. Keep it disconnected with the Data table. 

Then create the following measure and use it on the table visual as a filter. Set it to show items when value is 1. It will check the selected city first. If the city is in "Little Group Cities" table, return 1 for all products. If the city is not "little" one, return 1 when quantity is greater than or equal to 100. 

100 or more flag =
IF (
    SELECTEDVALUE ( 'Table'[City] ) IN VALUES ( 'Little Group Cities'[City] ),
    1,
    IF ( SUM ( 'Table'[Quantity] ) >= 100, 1, 0 )
)

I have attached the sample pbix at bottom. Hope it helps. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.