cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sharifahy
Helper II
Helper II

Manage Roles with Multiple Filters

Hi,

 

I need to filter my table by using the managing roles. When I try to use the DAX command in a calculated column, it works perfectly fine. However, in my manage roles the DAX is not working. Basically, I want to filter the Brand = "DEF" with their ItemId that Ends with "G". In manage roles, the brand wouldn't even show up in the report when role testing conducted.

 

Here is my DAX command for the calculated column

IF([Brand]="ABC" || AND([Brand]="DEF",RIGHT([ItemId],1)="G"),TRUE(),FALSE())

 

DAX command for manage role

[Brand] in {"ABC"} || AND([Brand]="DEF",RIGHT([ItemId],1)="G")

 

1 ACCEPTED SOLUTION

Hi. It turns out that the table used was linked by the original/source table so the command used was still correct. Thanks 🙂 

View solution in original post

3 REPLIES 3
amitchandak
Super User IV
Super User IV

@sharifahy , this seems fine. Hop you have selected role to test

https://www.tallan.com/blog/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi @amitchandak yes I do select the role. However, brand DEF does not appear in the report when I select and test the role. I need to filter multiple field which comprehend Brand must be DEF AND the item code must ends with G.

Hi. It turns out that the table used was linked by the original/source table so the command used was still correct. Thanks 🙂 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors