Protecting individual privacy - How do I require at least 5 records before data is displayed

[ARichman]

I want to publish a set of reports to be used in our office (and maybe with some individuals outside our office). I don't want users to be able to slice down to a level which would show them the data for a single record, as individual information is sensitive. So, what I want is a "check" after a slicer is used to ensure that at least 5 records are present before the aggregated results are displayed. If a slicer reduces to n<5 I just want reports to be blank.

[Eric_Zhang]

---

@ARichman wrote:

I want to publish a set of reports to be used in our office (and maybe with some individuals outside our office). I don't want users to be able to slice down to a level which would show them the data for a single record, as individual information is sensitive. So, what I want is a "check" after a slicer is used to ensure that at least 5 records are present before the aggregated results are displayed. If a slicer reduces to n<5 I just want reports to be blank.

---

I'd aggregate the dataset when loading, say aggreate the data via Power Query or via SQL Query when data is from database end.

[Greg_Deckler]

Hmm, if it was just one value, you could use HASONEVALUE function. For < 5, perhaps you could create a measure that counts the number of records involved but you would likely need a custom visual to take such a thing into account. Will noodle on it.