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
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.
Thanks mate,
but this did not work.
The table in the origianl post. If this works, I would not be able to see anyone with an employee count of 2 or less.
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |