Setting Row Level Security for multiple of values

0 votes

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.

image

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!

Apr 26 in Tableau by Neha
• 6,260 points
22 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Tableau

0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,230 points
1,947 views
0 votes
1 answer

Row level security in Tableau

I tried changing the user name column ...READ MORE

answered Mar 28 in Tableau by Neha
• 6,260 points
69 views
0 votes
1 answer

How can I add a row number for a specific field?

Hi @Noob, You can use RANK_DENSE function: "The function returns the ...READ MORE

answered Apr 17, 2018 in Tableau by sdfg
• 5,550 points
480 views
0 votes
1 answer

Creating a calculated field for summing up the values

Well you can use this in your ...READ MORE

answered May 18, 2018 in Tableau by sdfg
• 5,550 points
237 views
0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
10,875 views
0 votes
1 answer

Tableau Data Blend Performance + Level of Detail

If you are able to upgrade to ...READ MORE

answered Aug 24, 2018 in Tableau by AwesomeSauce
• 860 points
222 views
0 votes
1 answer

Bar chart : Arranging in descending order using data from another chart

Select treemap.  Make it active.  Turn on Visual Interactions ...READ MORE

answered Feb 8, 2019 in Power BI by Upasana
• 8,620 points
221 views
0 votes
0 answers

Calculate average speed in Powerbi using DAX

I have information from two cameras: the ...READ MORE

Apr 26 in Power BI by Neha
• 6,260 points
23 views
0 votes
1 answer

Which one should I choose Tableau or Power BI?

Hi Grim, Both the BI tools - Tableau ...READ MORE

answered Apr 6, 2018 in Tableau by ghost
• 1,790 points
265 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,220 points

edited Oct 11, 2018 by Kalgi 1,214 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP