Suppress matrix row total when exactly one value in the row is suppressed

[PattiNicholes]

I would like to suppress the row total in a large number of matrices in a report when exactly one value is suppressed in a row.  Using a measure, I am suppressing all values less than 11 and replacing them with a double asterisk (**) to denote that the data has been suppressed.  However, if there is only one suppresesd value, the value can be derived by adding up all of the non-suppressed values and subtracting from the total.  I'd like to replace those row totals with a double asterisk to prevent this possibility.

[Sahir_Maharaj]

Hello @PattiNicholes,

Can you please try this approach:

1. Create a measure to suppress individual values less than 11

SuppressedValue = 
IF(
    [YourMeasure] < 11, 
    BLANK(), 
    [YourMeasure]
)

2. Create a measure to check if exactly one value in the row is suppressed

CountSuppressed = 
CALCULATE(
    COUNTROWS(
        FILTER(
            VALUES('YourTable'[YourColumn]), 
            [YourMeasure] < 11
        )
    ),
    ALLSELECTED('YourTable')
)

3. Create a measure to conditionally suppress the row total

ConditionalRowTotal = 
IF(
    [CountSuppressed] = 1, 
    BLANK(), 
    SUMX(
        VALUES('YourTable'[YourColumn]), 
        [SuppressedValue]
    )
)

You can set up conditional formatting to show double asterisks in place of BLANK

DisplayMeasure = 
IF(
    ISBLANK([ConditionalRowTotal]), 
    "**", 
    FORMAT([ConditionalRowTotal], "0")
)

[PattiNicholes]

I think this is going to cause issues where the value is actually blank and not suppresessed.