Forum Discussion
Row level security
Hi , I’m new to power bi ,facing few issues please help, Created row level security for 3 levels , working correct for level 1 but for level 2 and 3 I can still see level 1 which I’m not intrested ....
Can you please try this approach.
PATHCONTAINS(
[Hierarchy],
LOOKUPVALUE(tbHeadCount[POSUserID],
tbHeadCount[Email],
USERPRINCIPALNAME()
)
)
used this dax to filter and get the count correct.i am getting the count correct for every level level but when am trying to see the visualisation its been showing all the levels from starting.for ex i logged in as manager the count is correct but it showing ceo first then if i drill down am seeing manger which i dont want...
am i clear please bear me in explaining things....
- Hi Anonymous
Can u please respond and help me in this.....