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.
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
Is this question the same as this one https://community.powerbi.com/t5/Desktop/Managing-Roles-Using-Measures-Is-it-Possible/m-p/745975/hig...?
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.
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 |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |