Forum Discussion

jbittinger's avatar
jbittinger
Regular Visitor
9 years ago
Solved

Exclude cells with small sample sizes

New to Power BI and trying to get my bearings. I'm working with survey (Likert-type) data in a university setting, and as a result, we are concerned about protecting the confidentiality of respondent...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    jbittinger

     

    Hi, Select the other chart and Go to Edit Interactions (Format Menu) and Select Filter instead of Highlight.

     

    Edit Interactions to Filter

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi jbittinger, we encountered this same problem as we have sensitive healthcare data. We were able to successfully suppress small numbers through the use of DAX formulas. Conceptually, the formula goes like this: "If the number to be displayed is less than n, then display '***', otherwise, display the number." An actual example is here: 

 

@JobsNoFilters = if( CALCULATE(COUNT(AppendAllPrograms[Job Number]))<=50,"***",CALCULATE(COUNT(AppendAllPrograms[Job Number]),ALL(AppendAllPrograms[Job Number])))
 
Cheers
  • jpb175's avatar
    jpb175
    Frequent Visitor
    7 years ago

    This was the fix to our issue.  Thanks!!
    I simplified the DAX formula you provided and got the output we expected:

    FixedField1 = if(CALCULATE(SUM(Table1[Field1]))<=5, "***", CALCULATE(SUM(Table1[Field1])))