Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

applying filters with minimum sample size

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:

 

RespondantCity 
TonyNew York
PeterNew York
BruceMiami
NickMiami
StevenMiami
NataliaMiami
StanMiami
GrootMiami
LoganMiami
Mary JaneMiami

 

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!

Need Help
Tutorial Requests
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    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
)

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Anonymous 

     

    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
)