Forum Discussion

acamar22's avatar
acamar22
Icon for Helper I rankHelper I
2 years ago

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

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!

 

Need Help

4 Replies

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      acamar22
      Icon for Helper I rankHelper I
      2 years ago

      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!

      • BA_Pete's avatar
        BA_Pete
        Icon for Super User rankSuper User
        2 years ago

         

        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