cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lokeshb31
Helper I
Helper I

Need help to implement requirement.

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.

1 ACCEPTED SOLUTION
lokeshb31
Helper I
Helper I

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)

View solution in original post

3 REPLIES 3
lokeshb31
Helper I
Helper I

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)

View solution in original post

alekhved
Resolver I
Resolver I

hi @lokeshb31 

 

Did you try adding this filter condition "tableA[recruiting_req] = "Yes")" in below section?

 

alekhved_0-1623908634840.png

 

 

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. 

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors