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,020 points
1,130 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
3,075 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,020 points
561 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,458 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
681 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
15,306 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
909 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
816 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,380 points
1,399 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
963 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,435 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