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 #...
Need Help
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

    • j_ocean's avatar
      j_ocean
      Icon for Helper V rankHelper V
      2 years ago

      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.