Creating a Security Filter to protect employee ID

[Anonymous]

I am trying to limit the exposure of identifing data by applying a filter to exisiting graphs. I would like the items to display "N/A" when the number of employees falls below 3. I have tried many "If / And statements" and all have failed.  I don't want to limit the data by not showing that there is data if below 3 (e.g. filter on [#of Employees] < 3). I would just like to display a blank or N/A. Any help would be greatful. 

[v-lid-msft]

Hi @Anonymous ,

We can try to add a condition to measure to meet your information, For example, if you want to show the Sum('Table'[Sales]), we can use the following measure:

Measure = IF(CALCULATE(DISTINCTCOUNT('Table'[Employee]),ALLSELECTED('Table'))<3,"N/A",SUM('Table'[Sales]) & "")

If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared？

Best regards,

[Anonymous]

The hope is to hide the data of individuals should the slicers make the data possibly idenifiable. 

[amitchandak]

Refer this can help

https://community.powerbi.com/t5/Desktop/How-to-count-selected-items-in-slicer/td-p/633902