Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lokeshb31
Helper II
Helper II

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 II
Helper II

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 II
Helper II

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)

Anonymous
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors