Matrix - How to remove row subtotal on rows with more than 1 data point?

[acamar22]

Hi everyone, thanks for clicking on my question!

I'm looking to remove row subtotals on rows that have multiple data entries as shown below:

I would like for them to appear ONLY when the "Part #" is expanded.

This is the expanded data set if needed:

Alternatively, is there a way to remove the [+/-] expand button for rows with only 1 data point? If so, I could use ISINSCOPE() to remove the remaining subtotals.

Thanks for any help!

[BA_Pete]

Hi @acamar22 ,

For the 'First Failure' subtotals, I think you could do something with HASONEVALUE in your measure, maybe something like this:

First Failure =
IF(
    HASONEVALUE(YourTable[AnimalName]),
    [CurrentFirstFailureCalculation]
)

For the [+/-] buttons, I think they're either on or off and that's it.

Pete

[acamar22]

Hey @BA_Pete thanks for your help.

I apologize, I didn't correctly demonstrate the data with the examples i provided.

The problem is that there are some rows with multiple [Animal Names], so it doesn't truly only have 1 value.

Any ideas on how to work around this?

I would still like it to display where it's circled.

Thanks again!

[j_ocean]

So for example you want a total on 3333 and 4444, but not Tiger?

I think this is in the visual options, go to subtotals by level and toggle off the ones you don't want.

[BA_Pete]

Ah, I see.

Then I think you were correct initially: You'll probably get what you need using ISINSCOPE([Animal Names]). Put an IF or SWITCH around it to ensure you get blanks when it's not in scope.

Pete