topic Re: (Managing Roles) Assigning Row-Level Security with Measures is Making Visuals Go Blank in Report Server

(Managing Roles) Assigning Row-Level Security with Measures is Making Visuals Go Blank

tmendoza — Wed, 17 Jul 2019 20:49:55 GMT

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

Re: (Managing Roles) Assigning Row-Level Security with Measures is Making Visuals Go Blank

d_gosbell — Mon, 22 Jul 2019 22:53:31 GMT

Is this question the same as this one https://community.powerbi.com/t5/Desktop/Managing-Roles-Using-Measures-Is-it-Possible/m-p/745975/highlight/false#M359597?

Re: (Managing Roles) Assigning Row-Level Security with Measures is Making Visuals Go Blank

tmendoza — Tue, 23 Jul 2019 16:02:22 GMT

That is correct,

I'll take down this post, since it's already been solved on the other one.

Now that I think of it, I'm not sure how to delte this post.