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

From your formula, the number of overdoses for each city/town for the filtered date range is not exist directly within your table, it needs to calculate based on the city and date range, right?

Since I don’t know the data model, I make a test with a simple data below using the formula to create a calculated column

city with suppression =
IF ( [ number of overdoses] < 10, "S", [city name] )

 

Could you offer more information as this article suggested so we could get an effective solution?

 

Best Regards

Maggie