Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Solved! Go to Solution.
Hi. It turns out that the table used was linked by the original/source table so the command used was still correct. Thanks 🙂
@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.
Hi. It turns out that the table used was linked by the original/source table so the command used was still correct. Thanks 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |