Switching Subtotals On and Off Dynamically Using DAX in PowerPivot
Subtotals on or off for a field - They're the options that you get. That's probably great for a lot of situations, but I would put money on the majority of readers of this post having had a situation where they've asked "where's the option to not display a subtotal when there's only one record being shown?". Frustrating isn't it? You end up with a load of subtotals simply repeating the same value as it's own one subset member because one of your other report elements has a subset of data that does need subtotalling. You can, of course, toggle the show and hide for each member, but wouldn't it be better if it was dynamic?
Read more...