managing roles

2 Topics

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")
Solved
Anonymous
5 years ago Place DAX Commands and Tips
6.1KViews
0likes
3Comments
(Managing Roles) Assigning Row-Level Security with Measures Is Making Visuals Go Blank
Hello all, This is my first time posting to the community, so I hope this works. I've been banging my head against my monitor trying to figure this one out. I've got a table that counts the number of employee's by their Job Title, Level and Job Family. What I'm trying to do is assign a Role that does not allow folks to see Rows that have an Employee Count of 2 or below. This could allow people to figure out salaries based off of the other visuals that express labor costs. "Employee Count" is a measure expressed by (DISTINCTCOUNT('Employee Detail'[Employee]). I'm trying to use this in my DAX formula; however, the formula is making all my visuals go blank. I've also tried this DAX expression that exclueds the measure, but still makes all my visuals blank. DISTINCTCOUNT([Employee])>"2". Can anyone offer my a solution that will allow me to create a role that will stop people seeing any rows that have an employee count of 2 or below. Thanks, Tom
tmendoza
7 years ago Place DAX Commands and Tips
1.8KViews
0likes
5Comments