Forum Discussion
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")
3 Replies
Anonymous , 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/
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.
