Forum Discussion

lokeshb31's avatar
lokeshb31
Icon for Helper II rankHelper II
5 years ago
Solved

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...
Need Help
Need Help DAX
  • lokeshb31's avatar
    lokeshb31
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

hi lokeshb31 

 

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

 

 

 

Thanks!

lokeshb31's avatar
lokeshb31
Icon for Helper II rankHelper II
5 years ago

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.