Preview a report on a security level

You want to put in place static RLS. You do not need a table Spain Manager. In the security roles you create add the filter on the specific country of your DIM Table you want to focus, not on users email AND not on the table you created.

For ex for Spain, choose something "MarketCode equals SPAIN". You add the specific users once you publish the reprot to Power Bi services