Forum Discussion

ScottA1423's avatar
ScottA1423
New Member
8 years ago
Solved

Suppressing data

I am building a dashboard that needs to suppress information when it may violate patient confidentiality. The dashboard includes the city of patients who present to the emergency department for accid...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi ScottA1423

    As i use your example, i replace "fewer than 10 " to "1", however it doesn't affect the result you want

    Try this measure 

    Measure =
IF (
    CALCULATE (
        SUM ( Table1[Drug Overdoses] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[City] ),
            Table1[Date] <= MAX ( 'Table'[Date] )
                && Table1[Date] >= MIN ( 'Table'[Date] )
        )
    )
        <= 1,
    "S",
    CALCULATE (
        SUM ( Table1[Drug Overdoses] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[City] ),
            Table1[Date] <= MAX ( 'Table'[Date] )
                && Table1[Date] >= MIN ( 'Table'[Date] )
        )
    )
)

    Best Regards

    Maggie

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi ScottA1423

As i use your example, i replace "fewer than 10 " to "1", however it doesn't affect the result you want

Try this measure 

Measure =
IF (
    CALCULATE (
        SUM ( Table1[Drug Overdoses] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[City] ),
            Table1[Date] <= MAX ( 'Table'[Date] )
                && Table1[Date] >= MIN ( 'Table'[Date] )
        )
    )
        <= 1,
    "S",
    CALCULATE (
        SUM ( Table1[Drug Overdoses] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[City] ),
            Table1[Date] <= MAX ( 'Table'[Date] )
                && Table1[Date] >= MIN ( 'Table'[Date] )
        )
    )
)

Best Regards

Maggie

 

jm-data's avatar
jm-data
Regular Visitor
3 years ago

Hi, great response, wondering if you can help with the following:

 

I need to suppress so that if less than a certain amount of participants have answered a certain question (when drilled down by slicers) it is not shown, but on top of that I need to suppress each graph to show that if less than 10 individuals answered a specific answer (out of a multiple choice of 7) then each individual bar should be suppressed and not shown.