I'm trying to build up row-level security in Power BI so that a user can only see data from the country to which they're linked. They can also view the data of other users, but only if they are both from the same nation. A user can be associated with multiple countries. Below is an example of data.
If user A accesses the Power BI report, for example, they will only be able to see data for the United States, Canada, Italy, and Germany. Also, if their countries are linked to the same country as user A, they can view the data of other users.
I attempted to use this DAX, but it would not work. Is it possible that I'll have to utilise something akin to an IN operator?
[Country] = CALCULATE( VALUES([Country]) , [User] = username() )
If this is doable, please let me know. Thank you very much in advance!