Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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
Proud to be a Datanaut!
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!
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.
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
Proud to be a Datanaut!