applying filters with minimum sample size

[jortega023]

Hi!

I am working on survey results with multiple filters in Power BI and I am concerned about protecting the confidentiality of respondents.

Applying a filter in a question, if the number of respondants is less than 5, the output wouldn't be visible.

In example:

Respondant	City
Tony	New York
Peter	New York
Bruce	Miami
Nick	Miami
Steven	Miami
Natalia	Miami
Stan	Miami
Groot	Miami
Logan	Miami
Mary Jane	Miami

Applying a filter for the column "City: New York", no results would be visible in the graphic, because there is only 2 people for that city) 

Is there an easy way to do that? I was trying to do a measure using IF functions, but i´m not getting the results I was looking for.

Thanks in advance!

[Zubair_Muhammad · Accepted solution]

@jortega023 

How about using a MEASURE as visual filter for the Table Visual.

In Visual Filter you can choose not equal to 1

MeasureforVisualFilter =
IF (
    CALCULATE ( COUNTROWS ( tableName ), ALLEXCEPT ( tableName, TableName[City] ) ) < 5,
    1
)