Switching Subtotals On and Off Dynamically Using DAX in PowerPivot
User Rating: / 0
PoorBest 
Written by David Churchward   
Sunday, 08 January 2012 17:25

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...

  Tags: dax
 

Pyramid+PowerPivot