topic Re: Manage Roles with Multiple Filters in DAX Commands and Tips

Manage Roles with Multiple Filters

Anonymous — Thu, 19 Nov 2020 03:45:35 GMT

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

Re: Manage Roles with Multiple Filters

amitchandak — Thu, 19 Nov 2020 04:56:07 GMT

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/

Re: Manage Roles with Multiple Filters

Anonymous — Thu, 19 Nov 2020 06:16:00 GMT

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.

Re: Manage Roles with Multiple Filters

Anonymous — Wed, 25 Nov 2020 01:37:38 GMT

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