Manage roles: How to set up correctly

[Anonymous]

Hello,

I have a report showing data for 8 departments. One type of user can see the data of all 8 departments. But I also need roles for users that can only see data of their department.

I have a slicer to select the department. In my main measure (that is then used in a lot of other measures) I used the selectedvalue of this slicer.

Value Sum =

VAR scl = [Selected Scale]

VAR dpt = [Selected Department]

RETURN

CALCULATE(

SUM(tabel_Transactions[Value])

;PATHCONTAINS(tbl_ProfitCentre[Path];dpt)

) / scl

When I want to create roles it is not working probably because I use selectedvalue in my measures?

E.g. I tried this managed role: 

[Department] = "Facilities"

But then no data is shown. 

I also tried to deselect any department in the slicer and that also does not work. 

Any idea how to solve?

[v-yuta-msft · Accepted solution]

@Anonymous ,

About how to build hierarchy RLS, I would suggest you refer to third-party blog below:

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.