Security Matrix - Roles

Question

Hi Everyone,

I have a tabular cube that contains Dimension "Employee" which contains informations on the employees (first name, last name, full name,country ...), other Dimension "Region" that contains the geographical informations (region=>country=>city=>site),other dimensions and a single fact table "Calls".

I want to create a role as follow :
* i can see all the countries (when i select column country of Dim region), also when i select a measure from the fact table, i still can see the total of all countries.

• the members of the role can see only the french data of the Dim employee (Employee.country = "France") when they select columns first name, last name, full name ... (see example below)

but they can see the total of the countries if they select the country column of Dim region without seeing employees of the other countries (see example below).

Is there any solution for creating this role ? and if yes, how to proceed ?

Answer 1

Hi,

For you need, normal Row Level Security would fit your scenario. I think you need to add another aggregate table to your model , with which user could see the total of other county but not the detail.

You could follow the steps in this article : Calculating Total, and Percentages in a Row-Level Security Power BI Model

Hope this would help.
Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November