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 Folks,
There is a requirement to implement confidentiality threshold across all tabs of power BI report where if the user makes a selection with fewer than 5 employees(if he is getting data fewer than 5), the data will not be shown. We have 9 tabs with different measures for calculation. Isnt there any top/row level security or DAX setup so that overall dashboard will display only values more than 5?
If not, I need to make changes in each measure which would be time consuming.
We are using following formula to calculate measure.
Recuiting_req = calculate(count(tableA[req_id]), filter(tableA, tableA[recruiting_req] = "Yes"))
Please guide how to achieve it.
Solved! Go to Solution.
I made changes to all measures which resolved the issue.
Recuiting_req = var vreq = calculate(count(tableA[req_id]), filter(tableA, tableA[recruiting_req] = "Yes"))
return
if (vreq<5, blank(), vreq)
I made changes to all measures which resolved the issue.
Recuiting_req = var vreq = calculate(count(tableA[req_id]), filter(tableA, tableA[recruiting_req] = "Yes"))
return
if (vreq<5, blank(), vreq)
hi @lokeshb31
Did you try adding this filter condition "tableA[recruiting_req] = "Yes")" in below section?
Thanks!
I am already adding that condition in a measure. I can not add that as a filter since there are multiple visual level filters and they may get affected. I am looking for something which will show data to useers only when its more than 5. e.g. I have HR dashboard and I am checking data for quarter or monthly basis in different tabs.... If there are less than 5 employees count in a visual, it should not be displayed.
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 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |