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)

lokeshb31's avatar
lokeshb31
Icon for Helper II rankHelper II
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)