Manage Roles with Multiple Filters

[Anonymous]

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")

[amitchandak]

@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/

[Anonymous]

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.

[Anonymous · 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 🙂