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
Hi, can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data?
Column1 | Column2 |
A | 1 |
B | 2.5 |
Specifically the Employee Detail table as well as the measures that you show in the visuals
As described here:
How to Get Your Question Answered Quickly
I can do better than that. I've got a PBIX file that has been redacted that has everything in it to mimic my problem. Just not sure how to send it out to the community.
usually peopple post on OneDrive Google Drive, would that work for you?
Sure does
cool, please post when you upload the file
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |