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
Icon for Community Support rankCommunity 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

  • ScottA1423's avatar
    ScottA1423
    New Member
    8 years ago

    Thank you I apologize for not providing enough detail! I did some searching to better explain my question, but first here is a sample of the applicable data. You'll see the date column is by date of an overdose occurence.

     

    DateDrug OverdosesCity
    Saturday, January 14, 20171Microsoftville
    Friday, January 27, 20171Google Hollow
    Monday, January 30, 20171Microsoftville
    Monday, January 30, 20171Apple Orchard
    Thursday, February 2, 20171Apple Orchard
    Thursday, February 23, 20171Apple Orchard
    Thursday, February 23, 20171Microsoftville
    Saturday, March 4, 20171Google Hollow
    Saturday, March 18, 20171Apple Orchard
    Tuesday, April 4, 20171Apple Orchard

     

    So what happens in my model is based on the date range the user filters for, a table visual populates with the City name and the total overdoses for that period. I am trying to set up a table that shows S instead of the number for fewer than 10 cases. See visuals below:

    Date filter

    Table

    • v-juanli-msft's avatar
      v-juanli-msft
      Icon for Community Support rankCommunity 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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Is it possible to have this be reflected in a stacked bar chart?
        So if some value is fewer than 10, have the chart label in a stacked bar chart display the character "S"? Thank you.