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, 2022 in Tableau by Neha
• 9,060 points
840 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,240 points
2,865 views
0 votes
1 answer

Row level security in Tableau

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

answered Mar 28, 2022 in Tableau by Neha
• 9,060 points
342 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 ffdfd
• 5,550 points
1,222 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 ffdfd
• 5,550 points
474 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
14,769 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
710 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
486 views
0 votes
1 answer

Calculate average speed in Powerbi using DAX

To calculate the average speed for automobiles ...READ MORE

answered Jun 20, 2023 in Power BI by Neelam
• 1,180 points
962 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
665 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 2,128 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP