Forum Discussion
(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
4 Replies
- v-yuta-msftCommunity Support
tmendoza ,
Please modify the dax expression as below:
distinctcount([Employee]) > 2
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- tmendozaResolver I
Thanks mate,
but this did not work.
- v-yuta-msftCommunity Support